-
Select CONCAT( 'delete from ', table_name, ';' )
-
FROM information_schema.tables
-
Where table_name LIKE 'instrument_%';
删除前缀相同的数据库表
最新推荐文章于 2021-07-13 11:07:13 发布
Select CONCAT( 'delete from ', table_name, ';' )
FROM information_schema.tables
Where table_name LIKE 'instrument_%';