mysql判断表中字段或者索引是否存在，如果不存在则创建

创建时间：2017-04-19 投稿人：浏览次数：117

判断字段是否存在：

DROP PROCEDURE IF EXISTS schema_change;  
DELIMITER //
CREATE PROCEDURE schema_change() BEGIN 
DECLARE  CurrentDatabase VARCHAR(100);
SELECT DATABASE() INTO CurrentDatabase;
IF NOT EXISTS (SELECT * FROM information_schema.statistics WHERE table_schema=CurrentDatabase AND table_name = "rtc_phototype" AND index_name = "index_name") THEN  
   ALTER TABLE `rtc_Phototype` ADD INDEX index_name ( `imgtype` );
END IF;  
END//  
DELIMITER ;  
CALL schema_change();

判断索引是否存在：

DROP PROCEDURE IF EXISTS schema_change;  
DELIMITER //
CREATE PROCEDURE schema_change() BEGIN 
DECLARE  CurrentDatabase VARCHAR(100);
SELECT DATABASE() INTO CurrentDatabase;
IF NOT EXISTS (SELECT * FROM information_schema.statistics WHERE table_schema=CurrentDatabase AND table_name = "rtc_phototype" AND index_name = "index_name") THEN  
   ALTER TABLE `rtc_Phototype` ADD INDEX index_name ( `imgtype` );
END IF;  
END//  
DELIMITER ;  
CALL schema_change();

声明：该文观点仅代表作者本人，入门客AI创业平台信息发布平台仅提供信息存储空间服务，如有疑问请联系rumenke@qq.com。