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