MySQL批量删除表

select CONCAT('drop table ',GROUP_CONCAT(str,'')) from (
		select CONCAT(table_name ) as str  FROM information_schema.tables
    where table_name REGEXP 't_phe_event_..'  
) s 

结果:

drop table 
t_phe_event_dynamic,t_phe_event_flow,t_phe_event_flow_time,t_phe_event_info,
t_phe_event_order,t_phe_event_order_flow,t_phe_event_order_supplies,t_phe_event_order_user,
t_phe_event_treat,t_phe_event_verify