msyql 的存储过程

Question

DELIMITER //CREATE PROCEDURE vba( sname VARCHAR(30))BEGINDECLARE eage INT DEFAULT 0;SELECT age FROM job WHERE NAME='sname'FROM abc;IF eage＞＝25 THEN,SELECT '合格' AS 结果;ELSESELECT '不合格' AS 结果;END IFEND //DELIMITER();DELIMITER //CREATE PROCEDURE vba( sname VARCHAR(30))BEGINDECLARE eage INT DEFAULT 0;SELECT age FROM job WHERE NAME='sname'FROM abc;IF eage＞＝25 THEN,SELECT '合格' AS 结果;ELSESELECT '不合格' AS 结果;END IFEND //DELIMITER();

Answer 1

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