转:https://blog.csdn.net/iw1210/article/details/79586033
1、生成全部truncate语句
SELECT CONCAT('truncate TABLE ',table_schema,'.',TABLE_NAME, ';') FROM INFORMATION_SCHEMA.TABLES WHERE table_schema IN ('数据库1','数据库2');
2、执行语句
转:https://blog.csdn.net/iw1210/article/details/79586033
1、生成全部truncate语句
SELECT CONCAT('truncate TABLE ',table_schema,'.',TABLE_NAME, ';') FROM INFORMATION_SCHEMA.TABLES WHERE table_schema IN ('数据库1','数据库2');
2、执行语句