Advertisement
Guest User

Untitled

a guest
Mar 25th, 2019
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. # Just copy the following lines changing [databasename] and execute it.
  2.  
  3. SELECT CONCAT('DROP TABLE ', GROUP_CONCAT(table_name SEPARATOR ','))
  4. AS delete_stmt INTO @query
  5. FROM information_schema.tables WHERE table_schema = '[databasename]';
  6. PREPARE stmt_drop FROM @query;
  7. EXECUTE stmt_drop;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement