mysql多库表添加字段脚本

-- 定义需要添加字段的表名列表
SET @tables = 'table1, table2, table3';

-- 构建动态SQL语句
SET @sql = CONCAT('ALTER TABLE ', @tables, ' ADD COLUMN created_at DATETIME DEFAULT CURRENT_TIMESTAMP;');

-- 执行动态SQL语句
PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;

SELECT CONCAT('CREATE TABLE IF NOT EXISTS ', table_name, ' (id INT AUTO_INCREMENT PRIMARY KEY);') 
INTO @create_table_sql 
FROM information_schema.tables 
WHERE table_schema = 'your_database_name' AND table_name IN ('table1', 'table2', 'table3');

PREPARE create_tables_stmt FROM @create_table_sql;
EXECUTE create_tables_stmt;
DEALLOCATE PREPARE create_tables_stmt;

SET @tables = 'table1, table2, table3';
SET @field_name = 'created_at';

SET @sql = CONCAT('ALTER TABLE ', @tables, ' ADD COLUMN IF NOT EXISTS ', @field_name, ' DATETIME DEFAULT CURRENT_TIMESTAMP;');

PREPARE stmt FROM @sql;
EXECUTE stmt;
DEALLOCATE PREPARE stmt;