MySQL

Stored Procedures Help please

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Oct 2009

Posts: 4

Reputation: badmanmc is an unknown quantity at this point

Solved Threads: 0

badmanmc

Offline

Newbie Poster

Stored Procedures Help please

Nov 1st, 2009

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:

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
CREATE OR REPLACE procedure delgroup
(g_id IN number)
 
IS
 
BEGIN
 
DELETE FROM grouptable WHERE GROUP_ID=g_id;
 
COMMIT;
END;
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

Last edited by peter_budo; Nov 1st, 2009 at 4:39 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)

•

Join Date: May 2007

Posts: 454

Reputation: Atli is on a distinguished road

Solved Threads: 56

Atli

Offline

Posting Pro in Training

Nov 1st, 2009

Hey.

You can see how MySQL procedures look like in the manual.

In your case it would look something like this:

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
DROP PROCEDURE IF EXISTS `delgroup`;
DELIMITER //
CREATE PROCEDURE `delgroup`(g_id INT)
BEGIN
    DELETE FROM grouptable WHERE GROUP_ID=g_id;
END//
DELIMITER ;
DROP PROCEDURE IF EXISTS `delgroup`;
DELIMITER //
CREATE PROCEDURE `delgroup`(g_id Int)
BEGIN
    DELETE FROM grouptable WHERE GROUP_ID=g_id;
END//
DELIMITER ;