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