Select CONCAT( 'drop table ', table_name, ‘;’ ) FROM information_schema.tables Where table_name LIKE ‘vm_list_log_2019%’;
mysql 拼接命令Concat
最新推荐文章于 2024-04-24 17:11:51 发布
Select CONCAT( 'drop table ', table_name, ‘;’ ) FROM information_schema.tables Where table_name LIKE ‘vm_list_log_2019%’;