牛骨文教育服务平台(让学习变的简单)
博文笔记

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

创建时间:2017-04-19 投稿人: 浏览次数:142


判断字段是否存在:

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();


声明:该文观点仅代表作者本人,牛骨文系教育信息发布平台,牛骨文仅提供信息存储空间服务。