Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # Just copy the following lines changing [databasename] and execute it.
- SELECT CONCAT('DROP TABLE ', GROUP_CONCAT(table_name SEPARATOR ','))
- AS delete_stmt INTO @query
- FROM information_schema.tables WHERE table_schema = '[databasename]';
- PREPARE stmt_drop FROM @query;
- EXECUTE stmt_drop;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement