msyql 的存储过程

Question

DELIMITER //

CREATE PROCEDURE vba( sname VARCHAR(30))

BEGIN

DECLARE eage INT DEFAULT 0;

SELECT age FROM job WHERE NAME='sname'FROM abc;

IF eage＞＝25 THEN,

SELECT '合格' AS 结果;

ELSE

SELECT '不合格' AS 结果;

END IF

END //

DELIMITER();

DELIMITER //

CREATE PROCEDURE vba( sname VARCHAR(30))

BEGIN

DECLARE eage INT DEFAULT 0;

SELECT age FROM job WHERE NAME='sname'FROM abc;

IF eage＞＝25 THEN,

SELECT '合格' AS 结果;

ELSE

SELECT '不合格' AS 结果;

END IF

END //

DELIMITER();

Answer 1

eage没赋值，赋值是select age into eage，还有就后面的那个FROM abc是什么鬼