使用
Select CONCAT( 'drop table ', table_name, ';' ) FROM information_schema.tables Where table_name LIKE '__prefix_%';
可生成drop表语句,然后可以批量删除:
drop table __prefix_20180129;
drop table __prefix_20180130;
drop table __prefix_20180131;
使用
Select CONCAT( 'drop table ', table_name, ';' ) FROM information_schema.tables Where table_name LIKE '__prefix_%';
可生成drop表语句,然后可以批量删除:
drop table __prefix_20180129;
drop table __prefix_20180130;
drop table __prefix_20180131;