【Mysql】更新脚本SQL——新增索引

DROP PROCEDURE
IF EXISTS schema_change;  
DELIMITER //

CREATE PROCEDURE schema_change ()
BEGIN

DECLARE CurrentDatabase VARCHAR (100) ; SELECT
	DATABASE () INTO CurrentDatabase ;
IF EXISTS (
	SELECT
		*
	FROM
	-- 注意这里 字段是 COLUMNS  索引是 TABLE_CONSTRAINTS 
		information_schema.TABLE_CONSTRAINTS 
	WHERE
		table_schema = CurrentDatabase
	AND table_name = '表名'
	AND CONSTRAINT_NAME = '索引名称'
) THEN
	-- 你操作数据库索引后可视化编辑器以后生成的SQL
END
IF ;
END//  
DELIMITER ;
CALL schema_change ();