MySQL Forums
Forum List  »  Stored Procedures

Error #1064
Posted by: Benjamin Maisonet
Date: December 25, 2017 08:05PM

I'm having an issue with my code. Here's the code:

USE
u287800102_mfcat;
CREATE
PROCEDURE simpleproc(
IN play TEXT,
IN LENGTH TEXT,
IN trackdescription TEXT,
IN genre TEXT,
IN subgenre TEXT,
IN tempo TEXT,
IN energy TEXT,
IN moods TEXT,
IN composer TEXT,
IN composerid TEXT,
IN download TEXT,
IN title TEXT,
IN uniqueid TEXT,
IN attribution TEXT,
IN attributionlink TEXT
);
END

I'm getting this error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CREATE
PROCEDURE simpleproc(
IN play TEXT' at line 3


What am I doing wrong? Thanks in advance!

Options: ReplyQuote


Subject
Views
Written By
Posted
Error #1064
2277
December 25, 2017 08:05PM
584
December 25, 2017 10:43PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.