Помогите пожалуйста с ошибкой MySQL Workbench И можете пояснить!
Генрий Юрий
Ученик
(182),
на голосовании
2 года назад
DELIMITER // CREATE FUNCTION iskakislam.get_name_glasses (PID INT) RETURNS VARCHAR(80) character set utf8 BEGIN DECLARE NAME_FOUNT TEXT DEFAULT ""; SELECT NAME_GLASSES INTO NAME_FOUND FROM iskakislam.glasses WHERE ID=PID; RETURN NAME_FOUND; END // DELIMITER ;
CREATE FUNCTION iskakislam.get_name_glasses (PID INT)
RETURNS VARCHAR(80) character set utf8
BEGIN
DECLARE NAME_FOUNT TEXT DEFAULT "";
SELECT NAME_GLASSES INTO NAME_FOUND FROM iskakislam.glasses WHERE ID=PID;
RETURN NAME_FOUND;
END //
DELIMITER ;
SELECT iskakislam.get_name_glasses(1);
Error Code: 1327. Undeclared variable: NAME_FOUND 0.000 sec