Stored Procedures Help please

[badmanmc]

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

[rakesh]

you can do like this


DELIMITER $$

DROP PROCEDURE IF EXISTS `yourschemaname`.`delgroup` $$
CREATE PROCEDURE `yourschemaname`.`delgroup` (g_id in number)
BEGIN
DELETE FROM grouptable WHERE GROUP_ID=g_id;

commit;

END $$

DELIMITER ;