MySQL Forums
Forum List  »  Newbie

Rename Stored Procedure Syntax
Posted by: Ruan de Villiers
Date: August 04, 2009 04:58AM

Hi All...

I am sitting with a situation where i need to Rename a stored Procedure and Not drop it. Reason for this is that i need it for a backup. I searched all over the web for a Example and all i can get is this darn "useless example"(for me)

ALTER {PROCEDURE | FUNCTION} sp_name [characteristic ...]

characteristic:
NAME newname
| SQL SECURITY {DEFINER | INVOKER}
| COMMENT string

found at
http://teaching-2.cs.uml.edu/MySQLdocs/MySQL_Manual/ALTER_PROCEDURE.html

In the first place this does not work for me it gives me an error.
can someone please just give me an example as to how to rename a Stored Procedure.

Options: ReplyQuote


Subject
Written By
Posted
Rename Stored Procedure Syntax
August 04, 2009 04:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.