先执行select语句生成所有truncate语句语句格式:select CONCAT(‘truncate TABLE ‘,TABLE_NAME, ‘;’) from INFORMATION_SCHEMA.TABLES where table_schema in (‘库’);