Stored Procedures Help please

Expand Post »

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:

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)

badmanmc

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

4 posts
since Oct 2009

Permalink

Nov 1st, 2009

Re: Stored Procedures Help please

Hey.

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

In your case it would look something like this:

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 ;

Note, the DELIMITER commands and the trailing // on END are only required if you are running this through the MySQL CLI, or other such interfaces.

Last edited by Atli; Nov 1st, 2009 at 1:01 pm.

Atli

Reputation Points: 93

Solved Threads: 70

Posting Pro

Offline

526 posts
since May 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MySQL Forum Timeline: MySQL Query - Searching for multiple keywords

Next Thread in MySQL Forum Timeline: SET datatype

DaniWeb Message

Cancel Changes

User Name
Password