DELIMITER $$
DROP PROCEDURE IF EXISTS Alter_Cluster;
CREATE PROCEDURE Alter_Cluster ()
BEGIN
IF NOT EXISTS (
SELECT
*
FROM
INFORMATION_SCHEMA. COLUMNS
WHERE
table_name = 'cluster_info'
AND column_name = 'region_type'
) THEN
ALTER TABLE `cluster_info` ADD `region_type` VARCHAR (10) DEFAULT '0' COMMENT '集群域类型,0表示普通域,1表示中心域,2表示分中心域' ;
END
IF ;
END$$
DELIMITER ;
CALL Alter_Cluster();
DROP PROCEDURE IF EXISTS `Alter_Cluster`;
1.升级时,判断表字段是否存在DELIMITER $$DROP PROCEDURE IF EXISTS Alter_Cluster;CREATE PROCEDURE Alter_Cluster ()BEGINIF NOT EXISTS ( SELECT * FROM INFORMATION_SCHEMA. COLUMNS WHERE table_name = 'cluster_info' AND column_name = 'regi