批量生成删除表数据的SQL语句

select CONCAT('TRUNCATE TABLE ', TABLE_SCHEMA, '.', table_name,';') from information_schema.tables where TABLE_SCHEMA in ('saas');

posted @ 2020-11-24 11:12  屌丝大叔的笔记  阅读(355)  评论(0编辑  收藏  举报