- 使用以下语句,生成某个database中所有表的 Drop 语句,然后复制执行就可以啦
SELECT concat('DROP TABLE IF EXISTS ', table_name, ';')
FROM information_schema.tables
WHERE table_schema = 'gn_Bw8Db';
SELECT concat('DROP TABLE IF EXISTS ', table_name, ';')
FROM information_schema.tables
WHERE table_schema = 'gn_Bw8Db';