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
Last activity: Jun 24, 2022, 09:40 PM