Skip to content

Instantly share code, notes, and snippets.

@simongcc

simongcc/common_mysql.sql

Created January 15, 2014 08:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save simongcc/8432919 to your computer and use it in GitHub Desktop.
Save simongcc/8432919 to your computer and use it in GitHub Desktop.
Download ZIP
Common MySQL command for development
Raw
common_mysql.sql
#Select desired table and create "drop table" command for the them
SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' )
AS statement FROM information_schema.tables WHERE table_schema = 'SCHEMA_NAME' and table_name LIKE 'SOMETHING%';
Then copy and paste the result to use.
###
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment