52gmsy 发表于 2020-1-2 01:31:07

mysql批量truncate

select CONCAT('truncate TABLE ',table_schema,'.',TABLE_NAME, ';') from INFORMATION_SCHEMA.TABLES wheretable_schema in ('数据库名');
页: [1]
查看完整版本: mysql批量truncate