editing existing procedured in mysql

i am using mysql 5.1. i have written a procedure name proc. now i want to edit some codes in it. whats the way out?
i tried writing "create or replace procedure proc", but it shows error .
i tried "drop procedure if exists" but this also shows error.
please tell me what to do.

re: editing existing procedured in mysql

I never done this on command line (CLI). But you can do this easily with the help of GUI e.g. MySQL Query Browser. Otherwise drop the stored procedure and create again.

re: editing existing procedured in mysql

yes i am using mysql querybrowser. i will tell you what i've got.
if i right click on the procedure name showing under "schemata" in the right window pane , it shows an option as "edit procedure". when i click on that, the procedure opens in a new resulteset tab. i can edit the procedure there. but i cant find how to save the changes made. please help.

re: editing existing procedured in mysql

Hi.

This may not help you, seeing as you are using the GUI tool, but when I need to update my procedures via the CLI, I do something like this:

re: editing existing procedured in mysql

thanx a lot for your concern...it finally worked the way i wanted it to. :)..