Help with mysql query..

Status
Not open for further replies.

death_relic0

Distinguished
Sep 18, 2009
183
0
18,690
hey guys, was hoping u could help me out...

ok i do know some sql, but im new to mysql... and theres this simple query that i just cant figure out whats wrong with it...

CREATE PROCEDURE inserttoscrapbookSD
(owner1 VARCHAR(50),
poster1 VARCHAR(50),
Scrap1 VARCHAR(50),
Date_time1 DECIMAL,
InsertedOrNot DECIMAL
)
BEGIN

INSERT INTO scrapbook (Owner)

VALUES(owner1)

END

i know there are a lot of variables being passed, but just using one variable atm because if it works for one, itll work for all.. i tried with and without a semicolon (;) at the end of "END" but no luck.. it says

#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 'END' at line 14

thanks in advance
 

mgwildi

Honorable
Apr 20, 2012
8
0
10,510
hmm, i'm not that much into mysql, but i'd go with a missing semicolon at the end of the insert statement " ... VALUES(owner1) ;" and after the procedure definition "... END ;"
 

death_relic0

Distinguished
Sep 18, 2009
183
0
18,690



no luck, this is what i tried:

CREATE PROCEDURE inserttoscrapbookSD
(owner1 VARCHAR(50),
poster1 VARCHAR(50),
Scrap1 VARCHAR(50),
Date_time1 DECIMAL,
InsertedOrNot DECIMAL
)
BEGIN

INSERT INTO scrapbook (Owner)

VALUES(owner1);

END ;
 

mgwildi

Honorable
Apr 20, 2012
8
0
10,510
hmmm okay...! could it be about the parameters directions?

I just rapidly checked for mysql procedure syntax, I think you have to specify it for PROCEDURE (which doesn't seem to be the case when creating a FUNCTION)
 
Status
Not open for further replies.