select Concat('TRUNCATE TABLE ', TABLE_NAME, ';') from INFORMATION_SCHEMA.TABLES 转载于:https://www.cnblogs.com/heidsoft/p/3838481.html