MySQL Forums
Forum List  »  Stored Procedures

New to mysql from MS SQL
Posted by: dave hall
Date: September 06, 2005 03:27AM

This is a really simple question guys so please help me out.

I'm new to mysql from MS SQL and am trying to write a stored procedure that takes to values from a web page and put them in the db. However I can't seem to get the syntax right.

in SQL it would be:
CREATE PROCEDURE dave(@param1 int, @param2 int)

BEGIN
insert into test.customers (id1,id2) values (@param1,@param2)
END

Now I get error left right and centre in mysql! Please help. I'm sure once someone points me in the right direction I will be ok!

Many thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
New to mysql from MS SQL
2937
September 06, 2005 03:27AM
2018
September 06, 2005 11:49AM
1855
September 07, 2005 02:17AM
1750
September 07, 2005 07:27AM
1794
September 08, 2005 08:04AM
1873
September 13, 2005 04:03AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.