mysql删除固定前缀的表

Select CONCAT( 'drop table ', table_name, ';' ) 
FROM information_schema.tables 
Where table_name LIKE 'as_%';

　　列出来，所有，再执行

SET FOREIGN_KEY_CHECKS = 0;
-- DROP语句
drop table as_tongdun_loanevent_and_hitrules_out;
drop table as_tongdun_loanevent_and_outputfields_out;
drop table as_tongdun_loanevent_and_policyresult_out;
drop table as_tongdun_loanevent_and_policyresult_policysethitrule_out;
SET FOREIGN_KEY_CHECKS = 1;

 SET FOREIGN_KEY_CHECKS = 0

-- DROP语句

SET FOREIGN_KEY_CHECKS = 1;