1064 mysql error with creating a procedure

Asked Jun 19 '14 at 14:59

Active Nov 25 '14 at 19:43

Viewed 77 times

I keep getting the following error:

1064 - 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 ''v_id' varchar(20) null , OUT 'v_status' varchar(40)) IS Begin ' at line 2

It is the first time I'm using MySql and the little pl sql knowledge isn't really helping.

delimiter //
->CREATE PROCEDURE dbi292801.campsite
(IN 'v_id' varchar(20) null ,
               OUT 'v_status' varchar(40)) IS
 Begin 
               SELECT status into v_status FROM participant WHERE RFID = v_id;
              if (v_status = "in", v_status := "at campsite", v_status := 'at event');
            End if;
            End //

If you have an idea to solve this, please reply!!

edited Nov 25 '14 at 19:43

Isaac Bennetch

11,830
2
32
43

asked Jun 19 '14 at 14:59

user3756977

Is the `->` intended, or a copy/paste artifact from your client? – Michael Berkowski Jun 19 '14 at 15:02
See [When to use single quotes, double quotes, backticks](http://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-backticks) -- variables, like column identifiers should be unquoted or quoted with backticks, not single quotes. – Michael Berkowski Jun 19 '14 at 15:03
So `v_id, v_status` rather than `'v_id', 'v_status'`, but there may be other syntax problems I am not seeing (the `IS` keyword?) – Michael Berkowski Jun 19 '14 at 15:04
[This is the MySQL CREATE PROCEDURE syntax reference](http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html) – Michael Berkowski Jun 19 '14 at 15:05
oh sorry the -> is copy past error! – user3756977 Jun 19 '14 at 15:21
i deleted the single quotes thanks, but the error remains – user3756977 Jun 19 '14 at 15:22
Exact same error or different? – Michael Berkowski Jun 19 '14 at 17:02

1064 mysql error with creating a procedure

0 Answers0