help with mysql query..

[ahmed anas]

salam, 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

 

[umairhaque]

Boss i think issue in Date_Time you are passing in Decimal format and time format is different than that... I did not use mysql.. but i use sql.

 

[hotgamerft]

Oops sorry.

 

[ahmed anas]

nope....no luck

 

[umar]

I never used stored procedures in mysql so im not sure, but i think the delimiter is causing the problem. try this

[INDENT]
mysql> DELIMITER $$
[/INDENT]
Note that there is no semicolon after the ‘$$’ symbol, which we will use as the delimiter for our purposes. 
You have to choose a delimiter that does not appear in your procedure, and it can be more than one character.[INDENT]
mysql> CREATE PROCEDURE usp_ins (P VARCHAR(10))    
-> BEGIN   
->  SET @x=CHAR_LENGTH(P);    
->  SET @y = HEX(P);    
->  INSERT INTO tmptest(id,txt) VALUES(@x,@y);    
-> END$$

Query OK, 0 rows affected (0.05 sec)

mysql> CALL usp_ins('ABC');   
 -> $$Query OK, 1 row affected (0.00 sec)[/INDENT]

so you need to set the delimiter and use "@" in values in your insert statement, hope this helps