The title says it all. I can't seem to google the syntax for editing an already-created stored procedure in MySQL.
I'd be happy with a link.
+5
A:
You can change certain attributes using the ALTER PROCEDURE syntax
To change the procedure body you will have to drop and recreate the entire procedure, in this case SHOW CREATE PROCEDURE may be useful
Neil Aitken
2010-04-01 11:31:43
+1
A:
In addition to what Neil Aitken said and provided you work on windows, you can download Toad for MySQL by Quest Software, a free and very usefull IDE for MySQL.
Toad has tools (=GUIs to SP, Tables, Views and more) that enable you to edit stored procedures in an editor and will even show you the syntax used execute many commands!
lexu
2010-04-01 11:37:16
From what i've seen Toad is a great tool, I must get around to learning it.
Neil Aitken
2010-04-01 11:38:46
@Neil Aitken: Toad is great, I mostly apreciate it's facilitating 'autodidactic' learning by letting me see the SQL-incantation it will use to do my bidding!
lexu
2010-04-01 11:42:01
Isn't SQL Management Studio quite similar to toad?
Frank
2010-04-01 11:48:26
Lol @ SQL-incantation, it does feel like that sometimes.Downloading the freweware edition now, I've been after a new tool for ages.
Neil Aitken
2010-04-01 11:48:28
@Frank: I don't know **'SQL Management Studio'** , the web seems to suggest it's a microsoft app aimed at MS SQL-Server. If that's not what your talking about: where can I find it?
lexu
2010-04-01 12:02:18
I'm working on Linux. Is there a similar recommendation?
FarmBoy
2010-04-01 12:28:20
@lexu : It is a Microsoft app, I find it very powerfull, however if you are on Linux Toad might be your best option.
Frank
2010-04-01 12:31:49
@FarmBoy: I believe toad will work with wine. But there might be a native app, I just don't know!
lexu
2010-04-01 13:18:36