DELIMITER $$CREATE PROCEDURE Alter_Table()BEGIN DECLARE _count INT; SET _count = ( SELECt COUNT(*) FROM INFORMATION_SCHEMA.COLUMNS WHERe TABLE_NAME = 'email_subscription' AND COLUMN_NAME = 'subscribe_all'); IF _count = 0 THEN ALTER TABLE email_subscription ADD COLUMN subscribe_all TINYINT(1) DEFAULT 1, ADD COLUMN subscribe_category varchar(512) DEFAULT NULL; END IF;END $$DELIMITER ;
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)