Sample Header Ad - 728x90

MySQL syntax error 1064 near IN stored procedure

0 votes
1 answer
1531 views
an aspiring DBA Here. I'm trying to create a stored procedure for a query I'm running. It is a memsql server which is MySQL based. The procedure is as such: delimiter // CREATE PROCEDURE calc_campaign (IN usr VARCHAR(38)) BEGIN Awesome SELECT statement that uses a variable END // The error description is: ERROR 1064 (42000): 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 'IN usr VARCHAR(38)) BEGIN my_statement; END' at line 1 The syntax I used seems to correspond with this: https://dev.mysql.com/doc/refman/8.0/en/create-procedure.html And with pretty much every other procedure I saw on Stack forums. What is it I'm missing here? Thanks for any help!
Asked by Nexaspx (123 rep)
Dec 6, 2018, 10:08 AM
Last activity: Jun 24, 2022, 09:40 PM