Problem For Create Sp !

[kamrava]

Hi dears

this is my first SP with yog

when i Exce it there are some errors . what is my wrong?

CREATE PROCEDURE save_user


@id VARCHAR(50)


@name VARCHAR(50)


@lname VARCHAR(50)


AS


IF LTRIM(RTRIM(@id))<>''


BEGIN


INSERT INTO user VALUES(id=@id,uname=@name)


END

and these errors :

Query: CREATE PROCEDURE save_user @id VARCHAR(50) @name VARCHAR(50) @lname VARCHAR(50) AS IF LTRIM(RTRIM(@id))<>'' BEGIN INSERT INTO us...





Error Code: 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 '@id VARCHAR(50)


@name VARCHAR(50)


@lname VARCHAR(50)


AS


IF LTRIM(RTRIM(@id))<>''' at line 2





Execution Time : 0 sec


Transfer Time  : 0 sec


Total Time	 : 0.001 sec

thank you all

[Author]

Posts