content_image/833973.jpg
stored routines, loadable functions, and tables in such cases are specifically not permitted, and fail with an error (see Bug #22830). 

Although an ALTER EVENT  statement that contains another ALTER EVENT  statement in its DO  clause appears to succeed, when the server attempts to execute the resulting scheduled event, the execution fails with an error. 

To rename an event, use the ALTER EVENT  statement’s RENAME TO  clause. This statement renames the event myevent  to yourevent : 

ALTER EVENT myevent RENAME TO yourevent; 

You can also move an event to a different database using ALTER EVENT ... RENAME TO ...  and db_name.event_name  notation, as shown here: 

ALTER EVENT olddb.myevent RENAME TO newdb.myevent; 

To execute the previous statement, the user executing it must have the EVENT  privilege on both the olddb and newdb  databases. 

<img src='content_image/833973.jpg'>

## Note 

There is no RENAME EVENT  statement. 

The value DISABLE ON SLAVE  is used on a replica instead of ENABLE  or DISABLE  to indicate an event that was created on the replication source server and replicated to the replica, but that is not executed on the replica. Normally, DISABLE ON SLAVE  is set automatically as required; however, there are some circumstances under which you may want or need to change it manually. See Section 17.5.1.16, “Replication of Invoked Features” , for more information. 

## 13.1.4 ALTER FUNCTION Statement 

ALTER FUNCTION func_name  [ characteristic  ...] characteristic : { COMMENT ’ string ’ | LANGUAGE SQL | { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA } | SQL SECURITY { DEFINER | INVOKER } } 

This statement can be used to change the characteristics of a stored function. More than one change may be specified in an ALTER FUNCTION  statement. However, you cannot change the parameters or body of a stored function using this statement; to make such changes, you must drop and re-create the function using DROP FUNCTION  and CREATE FUNCTION . 

You must have the ALTER ROUTINE  privilege for the function. (That privilege is granted automatically to the function creator.) If binary logging is enabled, the ALTER FUNCTION  statement might also require the SUPER  privilege, as described in Section 25.7, “Stored Program Binary Logging” . 

## 13.1.5 ALTER INSTANCE Statement 

ALTER INSTANCE instance_action instance_action : { | {ENABLE|DISABLE} INNODB REDO_LOG | ROTATE INNODB MASTER KEY 

