Skip to content

Instantly share code, notes, and snippets.

@sankars

sankars/mysql_ddl.sql

Created April 29, 2014 06:12
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save sankars/11391807 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save sankars/11391807 to your computer and use it in GitHub Desktop.
Download ZIP
Mysql queries dealing with structures of tables and views
Raw
mysql_ddl.sql
-- From http://stackoverflow.com/questions/5452760/truncate-foreign-key-constrained-table
SET FOREIGN_KEY_CHECKS=0;
TRUNCATE table1;
TRUNCATE table2;
SET FOREIGN_KEY_CHECKS=1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment