mysql 批量删表197

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

原文地址:https://www.cnblogs.com/Ai-Hen-Jiao-zhi/p/11634563.html