Skip to content

Instantly share code, notes, and snippets.

@neewbee

neewbee/batch_delete_database.sql

Created September 28, 2017 07:39
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save neewbee/27a96f0dc035940e32b120a57bf4b962 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save neewbee/27a96f0dc035940e32b120a57bf4b962 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. neewbee created this gist Sep 28, 2017.
    3 changes: 3 additions & 0 deletions batch_delete_database.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,3 @@
    SELECT CONCAT('DROP DATABASE `', SCHEMA_NAME, '`;')
    FROM `information_schema`.`SCHEMATA`
    WHERE SCHEMA_NAME LIKE 'cms_%';