MySql字段增量DDL脚本

增加字段

创建存储过程：

CREATE PROCEDURE ADDIFNOTEXISTS(
IN _table varchar(50),
IN _column varchar(50),
in _desc varchar(200)
)
BEGIN
	DECLARE _ISEXISTS INT;
	SELECT COUNT(*) INTO _ISEXISTS FROM information_schema.`COLUMNS` C
	WHERE LOWER(C.TABLE_NAME) = LOWER(_table) AND LOWER(C.COLUMN_NAME) = LOWER(_column);
IF (_ISEXISTS = 0) THEN
set @sql = CONCAT('ALTER TABLE ',_table,' ADD ',_column,' ',_desc);
PREPARE stmt FROM @sql;
execute stmt;
END IF;
END;

调用：

CALL ADDIFNOTEXISTS('表名','字段名','字段类型');

修改和删除字段可以参照增加字段的方式写脚本。