查询一个数据库中相同前缀的表(pre代表表的前缀):
Select CONCAT( 'drop table ', table_name, '' ) FROM information_schema.tables Where table_name LIKE 'pre_%';
Select CONCAT( 'drop table ', table_name, '' )
FROM information_schema.tables
Where table_name LIKE 'pre_%';
每天 08:00~20:00