Thursday, 12 September 2013

Error 1064 on MySQL 5 database

Error 1064 on MySQL 5 database

I keep getting an error while trying to create a stored procedure. I am
using the following SQL:
CREATE PROCEDURE sp_add_mailing_list_item
(
IN paramA VARCHAR(50) ,
IN paramB VARCHAR(50) ,
IN paramC VARCHAR(255) ,
IN paramD DATE ,
IN paramE VARCHAR(255) ,
)
BEGIN
INSERT INTO MailingList
(
firstName ,
lastName ,
email ,
dob ,
notes
)
VALUES
(
paramA ,
paramB ,
paramC ,
paramD ,
paramE
)
END
I am pretty well versed in SQL (for MSSQL Server), but this is just
eluding me. Any help is appreciated. I have tried using a delimiter, but
that brings up all kinds of other errors.
Thanks.

No comments:

Post a Comment