增加字段
创建存储过程:
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('表名','字段名','字段类型');
修改和删除字段可以参照增加字段的方式写脚本。