Code: Select all
DELIMITER $$
DROP PROCEDURE IF EXISTS `dorknozzle`.`InsertHelpDesk`$$
CREATE PROCEDURE `dorknozzle`.`InsertHelpDesk`(?EmployeeID int, ?StationNumber int, ?CategoryID int, ?SubjectID int. ?Description varchar, ?StatusID int)
BEGIN
insert into HelpDesk(EmployeeID, StationNumber, CategoryID, SubjectID, Description, StatusID)
values(?EmployeeID, ?StationNumber, ?CategoryID, S?ubjectID, ?Description, ?StatusID)
END$$
DELIMITER ;please help. thanks in advanceError Code : 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 '?EmployeeID int, ?StationNumber int, ?CategoryID int, ?SubjectID int. ?Descripti' at line 1