mysql可重复执行新增字段，修改字段脚本

最新推荐文章于 2024-07-03 03:18:33 发布

月慕向阳

最新推荐文章于 2024-07-03 03:18:33 发布

阅读量2.1k

点赞数

分类专栏： mysql

本文链接：https://blog.csdn.net/weixin_41796956/article/details/106408856

版权

mysql 专栏收录该内容

16 篇文章 3 订阅

订阅专栏

DROP PROCEDURE IF EXISTS add_tb_column;
DELIMITER $$
CREATE PROCEDURE add_tb_column()
    BEGIN
		DECLARE  CurrentDatabase VARCHAR(100);
		SELECT DATABASE() INTO CurrentDatabase;
        IF NOT EXISTS (SELECT 1 FROM information_schema.COLUMNS  WHERE   TABLE_SCHEMA=CurrentDatabase             
            AND TABLE_NAME='T_ICP_EVENT_INFO' 
            AND COLUMN_NAME='REPT_ORG_ID' )
		THEN
          ALTER TABLE T_ICP_EVENT_INFO ADD COLUMN REPT_ORG_ID VARCHAR(32) DEFAULT NULL COMMENT '单位ID';
        END IF;
		IF EXISTS (SELECT 1 FROM information_schema.COLUMNS  WHERE   TABLE_SCHEMA=CurrentDatabase             
            AND TABLE_NAME='T_ICP_EVENT_INFO' 
            AND COLUMN_NAME='REPT_ORG_ID' )
		THEN
          ALTER TABLE T_ICP_EVENT_INFO 
		  CHANGE `REPT_ORG_ID` `REPT_ORG_ID` VARCHAR(32)  COMMENT '单位ID';
        END IF;
  END
$$ 
DELIMITER ;
CALL add_tb_column;
DROP PROCEDURE add_tb_column;