Skip to content

Instantly share code, notes, and snippets.

@maztch

maztch/delete_by_prefix.sql

Last active August 29, 2015 14:25
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 maztch/54079c46e7546b6b5648 to your computer and use it in GitHub Desktop.
Save maztch/54079c46e7546b6b5648 to your computer and use it in GitHub Desktop.
Download ZIP
mysql delete tables by prefix
Raw
delete_by_prefix.sql
SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' )
AS statement FROM information_schema.tables
WHERE table_name LIKE 'prefix_%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment