Witam
chce stworzyć poniższą procedurkę w bazie:
CREATE PROCEDURE crm_timetable_msg (IN userid INTEGER, OUT text VARCHAR(255))
BEGIN SELECT timetable_description INTO text FROM timetable WHERE timetable_start < NOW() AND (timetable_end>NOW() OR timetable_end IS NULL) AND user_id = userid AND active=1
END
i dostaje:
MySQL ERROR:
You have an error IN your SQL syntax; CHECK the manual that corresponds TO your MySQL server version FOR the RIGHT syntax TO USE near 'SELECT timetable_description INTO text FROM timetable WHERE timetable_start < ' at line 3
QUERY:
CREATE PROCEDURE crm_timetable_msg (IN userid INTEGER, OUT text VARCHAR(255))
BEGIN SELECT timetable_description INTO text FROM timetable WHERE timetable_start < NOW() AND (timetable_end>NOW() OR timetable_end IS NULL) AND user_id = userid AND active=1
END
Czy ktoś może mi powiedzieć, gdzie popełniam błąd składni ? bo albo ja już mylę bazy, albo nie wiem...