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 MySQL are you targeting? The support for stored procedures varies considerably depending on the MySQL version.

Recent MySQL versions have pretty good support for stored procedures. Go back even a couple of years and the stored procedure support gets sketchy.

-PatP

im using the latest version..... 5.1.39

so any ideas on how i would convert that oracle procedure to mysql syntax?

MySQL 5.4 is the current version. You should probably start with the MySQL documentation for CREATE PROCEDURE. The documentation will let you know what your options are, which may affect some of the choices that you make in coding the procedure.

-PatP