ALTER PROCEDURE and ALTER FUNCTION Syntax : Function : Procedure Function MySQL TUTORIALS

MySQL TUTORIALS » Procedure Function » Function »

ALTER PROCEDURE and ALTER FUNCTION Syntax

This statement can be used to change the characteristics of a stored procedure or function.

More than one change may be specified in an ALTER PROCEDURE or ALTER FUNCTION statement.


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

characteristic:
    { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
  | SQL SECURITY { DEFINER | INVOKER }
  | COMMENT 'string'

Related Scripts with Example Source Code in same category :

Creating Functions
A function that takes a parameter, performs an operation using an SQL function, and returns the result
Single statement function
Nested function call
Using buildin function in user-defined function
Changing and Removing Functions
To remove a stored function, use the DROP command
Create a procedure for 'READS SQL DATA'
DROP PROCEDURE and DROP FUNCTION Syntax
Function Permissions

MySQL TUTORIALS

Procedure Function
» Function

Aggregate Functions

Cast Functions Operators

Comparison Functions Operators

Control Flow Functions

Cursor

Data Dictionary

Data Types

Database

Date Time Functions

Encryption Compression Functions

Information Functions

Insert Update Delete

Introduction

Logic Operator

Math Numeric Functions

Miscellaneous Functions

Privilege

Subquery

Table

Table Join

Trigger

View

ALTER PROCEDURE and ALTER FUNCTION Syntax : Function : Procedure Function MySQL TUTORIALS

MySQL TUTORIALS » Procedure Function » Function »

ALTER PROCEDURE and ALTER FUNCTION Syntax

Leave a Comment / Note

MySQL TUTORIALS