批量删除多张表，有统一前缀的

# 拼接 SQL，将数据库名和表前缀替换掉即可
select concat('drop table ', TABLE_NAME, ';') from information_schema.TABLES
where TABLE_SCHEMA = 'test' and TABLE_NAME like 'sxy_order_%'