sql,SET FOREIGN_KEY_CHECKS = 0;,-替换
your_database_name为你的数据库名,USE your_database_name;,-生成并执行删除数据的SQL语句,SELECT CONCAT('TRUNCATE TABLE ', table_name, ';') INTO @stmt,FROM information_schema.tables,WHERE table_schema = 'your_database_name' AND table_type = 'BASE TABLE';,PREPARE stmt FROM @stmt;,EXECUTE stmt;,DEALLOCATE PREPARE stmt;,SET FOREIGN_KEY_CHECKS = 1;,
``