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

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

原文地址:https://www.cnblogs.com/subendong/p/14029144.html