- 数据库:olympichr;
- 表:A01;
- 待添加字段:A0101;
- 待添加字段类型:VARCHAR(50);
- 待添加字段位置:A00字段之后;
DROP PROCEDURE IF EXISTS PRO_ADDCOLUMNS;
CREATE PROCEDURE PRO_ADDCOLUMNS() BEGIN DECLARE COUNT TINYINT DEFAULT 0;
SELECT
COUNT(*) INTO COUNT
FROM
information_schema.COLUMNS
WHERE
TABLE_SCHEMA = 'olympichr'
AND TABLE_NAME = 'A01'
AND COLUMN_NAME = 'A0101';
IF COUNT = 0 THEN -- 不存在,直接新增
ALTER TABLE
A01
ADD
A0101 VARCHAR(50) NULL comment '姓名' after A00;
END IF;
END;
CALL PRO_ADDCOLUMNS();
DROP PROCEDURE IF EXISTS PRO_ADDCOLUMNS;