Create a stored procedure for Students DB that will assign a Lecturer Assistant to a particular lecturer (based on its related tables). The IN parameters for the stored procedure are to be the relevant field values i.e lectureid, studentid, etc. The stored procedure will return the ID of the row inserted in the Lecturer Assistant table and should be returned via and OUT parameter.
This is what I have so far.....
CREATE PROCEDURE assistant(lecId, subjectLecId, studId INT, OUT lAssistantId INT)
INSERT INTO lec_assistant (lec_assistant_id, subject_lec_id, stud_id) VALUES(NULL,sujectLecId,studId);
I'm getting this error:
#1064 - 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 'subjectLecId, studId INT, OUT lAssistantId INT) INSERT INTO lec_assistant (lec_a' at line 1
Could anyone please assist in telling me if a correction needs to be made to the syntax? I'm using WAMPSERVER 2.0