MYSQL 没有索引则创建索引

DROP PROCEDURE IF EXISTS ADD_INDEX();
DELIMITER ;;
CREATE PROCEDURE ADD_INDEX()
BEGIN
    DECLARE  target_table_name,target_index_name VARCHAR(100);

    SET target_table_name = 'XXX';
    SET target_index_name = 'XXXX';
    
    IF NOT EXISTS (SELECT * FROM information_schema.statistics WHERE table_schema = DATABASE() AND table_name = target_table_name AND index_name = target_index_name) THEN
        SET @statement = "ALTER TABLE XXX ADD INDEX  `XXXX` (`XX`)";
        PREPARE STMT FROM @statement;
        EXECUTE STMT;
    END IF;
END
;;
DELIMITER ;

CALL ADD_INDEX();