select concat('truncate table ',TABLE_NAME,';') from information_schema.`TABLES` where TABLE_SCHEMA='rks_rpsdb' and TABLE_NAME like 'O_%'
【笔记】 SQL
最新推荐文章于 2023-09-07 16:22:01 发布
select concat('truncate table ',TABLE_NAME,';') from information_schema.`TABLES` where TABLE_SCHEMA='rks_rpsdb' and TABLE_NAME like 'O_%'