mysql清空数据库中所有表

-- 设置要清空的数据库
USE your_database_name;

-- 获取所有表名
SET @tables = NULL;
SELECT GROUP_CONCAT(table_name) INTO @tables FROM information_schema.tables WHERE table_schema = DATABASE();

-- 循环遍历所有表并清空
SET @table_list = REPLACE(@tables, ',', ' ');

WHILE CHAR_LENGTH(@table_list) > 0 DO
  SET @table_name = SUBSTRING_INDEX(@table_list, ' ', 1);
  SET @table_list = TRIM(SUBSTRING_INDEX(@table_list, ' ', -1));

  SET @sql = CONCAT('TRUNCATE TABLE ', @table_name);
  PREPARE stmt FROM @sql;
  EXECUTE stmt;
  DEALLOCATE PREPARE stmt;
END WHILE;