Skip to content

Instantly share code, notes, and snippets.

@QuentinFonteneau

QuentinFonteneau/gist:822cb8978943a9fd45ed20e816d44730

Created August 12, 2018 14:30
Show Gist options
  • Save QuentinFonteneau/822cb8978943a9fd45ed20e816d44730 to your computer and use it in GitHub Desktop.
Save QuentinFonteneau/822cb8978943a9fd45ed20e816d44730 to your computer and use it in GitHub Desktop.
Download ZIP
Drop tables quickly
Raw
gistfile1.txt
SELECT concat('DROP TABLE IF EXISTS `', table_name, '`;')
FROM information_schema.tables
WHERE table_schema = 'MyDatabaseName';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment