如何创建返回不带元音的文本的存储过程

CREATE DATABASE YourDatabaseName;
USE YourDatabaseName;

CREATE TABLE TextData (
    ID INT PRIMARY KEY AUTO_INCREMENT,
    Text VARCHAR(255)
);

DELIMITER //

CREATE PROCEDURE RemoveVowels(IN textID INT)
BEGIN
    DECLARE inputText VARCHAR(255);
    DECLARE outputText VARCHAR(255);
    DECLARE i INT DEFAULT 1;
    
    SELECT Text INTO inputText FROM TextData WHERE ID = textID;
    
    SET outputText = '';
    
    WHILE i <= LENGTH(inputText) DO
        IF SUBSTRING(inputText, i, 1) NOT IN ('a', 'e', 'i', 'o', 'u', 'A', 'E', 'I', 'O', 'U') THEN
            SET outputText = CONCAT(outputText, SUBSTRING(inputText, i, 1));
        END IF;
        
        SET i = i + 1;
    END WHILE;
    
    SELECT outputText AS 'Result';
END //

DELIMITER ;

CALL RemoveVowels(1);