获取批量需要清空表数据的sql

select concat('delete from ',table_name,';') from information_schema.tables where table table_name like '%t_bid_%'

posted @ 2019-06-29 23:27  lamdan  阅读(316)  评论(0编辑  收藏  举报