SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' ) AS statement FROM information_schema.tables WHERE table_schema = 'test' AND table_name LIKE '%_2017%';
查询结果为drop table语句;
SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' ) AS statement FROM information_schema.tables WHERE table_schema = 'test' AND table_name LIKE '%_2017%';
查询结果为drop table语句;