一键生成清空所有表格记录SQL.

select CONCAT(‘truncate TABLE ‘,table_schema,’.',TABLE_NAME, ‘;’) from INFORMATION_SCHEMA.TABLES where table_schema in (‘数据库表名’);