如何在没有DROP数据库权限的情况下从命令行删除所有MySQL表？[重复]

您可以生成如下语句：

DROp TABLE t1, t2, t3, ...

SET FOREIGN_KEY_CHECKS = 0; SET @tables = NULL;SELECT GROUP_CONCAt('`', table_schema, '`.`', table_name, '`') INTO @tables  FROM information_schema.tables   WHERe table_schema = 'database_name'; -- specify DB name here.SET @tables = CONCAt('DROp TABLE ', @tables);PREPARE stmt FROM @tables;EXECUTE stmt;DEALLOCATE PREPARE stmt;SET FOREIGN_KEY_CHECKS = 1;