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
Subject
Views
Written By
Posted
New to mysql from MS SQL
3522
September 06, 2005 03:27AM
2121
September 06, 2005 11:49AM
1969
September 07, 2005 02:17AM
1857
September 07, 2005 07:27AM
1917
September 08, 2005 08:04AM
1952
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.