mysql 批量建表

-- 创建表的模板
SET @create_table_sql = 'CREATE TABLE IF NOT EXISTS `{table_name}` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `name` VARCHAR(255) NOT NULL,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;';

-- 定义表名列表
SET @table_names = 'table1,table2,table3';

-- 分割表名列表并循环创建表
SET @pos = 0;
SET @next_pos = 0;
SET @table_name = '';

WHILE @pos < LENGTH(@table_names) DO
  SET @next_pos = LOCATE(',', @table_names, @pos + 1);
  IF @next_pos = 0 THEN
    SET @next_pos = LENGTH(@table_names) + 1;
  END IF;
  SET @table_name = SUBSTRING(@table_names, @pos + 1, @next_pos - @pos - 1);
  SET @create_table_sql = REPLACE(@create_table_sql, '{table_name}', @table_name);
  PREPARE stmt FROM @create_table_sql;
  EXECUTE stmt;
  DEALLOCATE PREPARE stmt;
  SET @pos = @next_pos;
END WHILE;