CREATE PROCEDURE NOT WORKING IN SQL #1537
-
|
Hi everyone have been trying to create a procedure but I keep getting a syntax error any ideas how I can solve this..? All help is appreciated thanks..!!!! |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 1 reply
-
|
Is that missing semicolon at line 75 where the end SQL statement causes ? also the line 77 the for resetting the delimiter back to normal, the space is missing between the keyword https://www.mysqltutorial.org/getting-started-with-mysql-stored-procedures.aspx |
Beta Was this translation helpful? Give feedback.
-
|
Wow thank yhu so much that helped lol have been looking at it for hours but didnt spot the missing semi colon lmao |
Beta Was this translation helpful? Give feedback.
Is that missing semicolon at line 75 where the end SQL statement causes ?
also the line 77 the for resetting the delimiter back to normal, the space is missing between the keyword
https://www.mysqltutorial.org/getting-started-with-mysql-stored-procedures.aspx