查询一个数据库中相同前缀的表(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:30~17:30