mysql if语句报错

IF condition THEN
    -- 执行语句
ELSE
    -- 执行其他语句
END IF;

DELIMITER //

CREATE PROCEDURE ExampleProc(IN input INT)
BEGIN
    IF input > 10 THEN
        SELECT 'Greater than 10';
    ELSE
        SELECT 'Less than or equal to 10';
    END IF;
END //

DELIMITER ;

DELIMITER //

CREATE PROCEDURE ExampleProc(IN input INT)
BEGIN
    IF input > 10 THEN
        SELECT 'Greater than 10';
    ELSE
        SELECT 'Less than or equal to 10';
    END IF;
END //

DELIMITER ;

DELIMITER //

CREATE PROCEDURE ExampleProc(IN input INT)
BEGIN
    IF input > 10 THEN
        SELECT 'Greater than 10';
    ELSE
        SELECT 'Less than or equal to 10';
    END IF; -- 确保这里有END IF
END //

DELIMITER ;

DELIMITER //

CREATE PROCEDURE ExampleProc(IN input INT)
BEGIN
    IF input > 10 THEN
        SELECT 'Greater than 10';
    ELSE
        SELECT 'Less than or equal to 10';
    END IF;
END //

DELIMITER ;