Changing and Removing Functions : Function : Procedure Function MySQL TUTORIALS


MySQL TUTORIALS » Procedure Function » Function »

 

Changing and Removing Functions


MySQL provides an ALTER statement for stored functions.

The ALTER statement can change only the characteristics of a function, not the SQL statements that make up the body.

The ALTER statement has the following syntax:

You can change multiple characteristics within a single ALTER statement.

If a characteristic isn't specified in the statement, the value is left as it was when the function was created.

The DETERMINISTIC characteristic isn't allowed in the ALTER statement.

ALTER FUNCTION [database.];

ALTER FUNCTION test.myFunction
  COMMENT 'This is the new comment.';



Leave a Comment / Note


 
Verification is used to prevent unwanted posts (spam). .

Follow Navioo On Twitter

MySQL TUTORIALS

 Navioo Procedure Function
» Function