1 查询所有数据库表
SELECT CONCAT('DROP TABLE IF EXISTS ', table_name, ';')
FROM information_schema.tables
WHERE table_schema = '你的数据库名';
结果
DROP TABLE IF EXISTS app_score_info;
DROP TABLE IF EXISTS application_info;
DROP TABLE IF EXISTS application_setup_info;
DROP TABLE IF EXISTS application_version;
DROP TABLE IF EXISTS client;
DROP TABLE IF EXISTS comment;