生成删除数据库中所有表的sql语句
SELECT concat('DROP TABLE IF EXISTS ', table_name, ';') FROM information_schema.tables WHERE table_schema = 'deleteSchema';
生成删除数据库中所有表所有数据的sql语句
select CONCAT('TRUNCATE TABLE ', TABLE_SCHEMA, '.', table_name,';') from information_schema.tables where TABLE_SCHEMA in ('deleteSchema');