DELIMITER $$
DROP PROCEDURE IF EXISTS test_procedure $$
CREATE PROCEDURE test_procedure()
BEGIN
IF EXISTS(SELECT 1 FROM information_schema.COLUMNS
WHERE UPPER(table_schema) = UPPER('kirin')
AND UPPER(table_name) = UPPER('stu_info')
AND UPPER(column_name) = UPPER('stu_name')
) THEN ALTER TABLE kirin.stu_info MODIFY stu_name VARCHAR(50);
END IF;
END $$
DELIMITER ;
CALL kirin.test_procedure();
DROP PROCEDURE IF EXISTS kirin.test_procedure;