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