I have made stored procedures in Oracle...but need to export them to mysql. I have searched on google but cant figure out the syntax.

Here is the oracle procedure:


create or replace procedure delgroup
(g_id in number)
is
begin
DELETE FROM grouptable WHERE GROUP_ID=g_id;
commit;
end;


I jus basically want to delete the group from the group table..depending on which group id (the arguement) the user types in.

How would i do this exact same procedure in mysql?

Please some assistance guys

what version of the MySql server? and what storage engine?

SPs are only available from Ver5.0 and transactions (begin ... commit) are only functional if the engine is InnoDb (or DBD).

thanks for the reply comic book guy lol


umm i have mysql version 5.1.39 and whatever the default storage engine is. I have not touched any engine settings. I have vaguely heard of innoDb.

Basically the procedures will be used on the backend of a web application.

So do i just need to change the storage engine on the database and thats it? or does something need to be tweaked on the front end too?


1. how to change storage engine?

2. what is the correct mysql syntax for the procedure i have stated?


thanks a lot for your help!

SPs are pretty much the same if you use ANSI SQL
http://dev.mysql.com/doc/refman/5.0/...es-syntax.html

How to change engines may depend on what tools you have to manage the server/database(s)
http://dev.mysql.com/tech-resources/...ne/part_1.html

ok thanks i will try it out. Its still not working for me..im gettin a syntax error but il try troubleshooting and see what i can do. thanks for the reply