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;