select concat('DROP TABLE IF EXISTS ',table_name,";") from information_schema.tables where table_schema="db1";;
db1代表库名
executive-1314 2021-06-05 16:53 原文
select concat('DROP TABLE IF EXISTS ',table_name,";") from information_schema.tables where table_schema="db1";;
db1代表库名