Syntax for Changing store procedures : Procedure « Procedure Function « SQL / MySQL






  1. SQL / MySQL
  2. Procedure Function
  3. Procedure

Syntax for Changing store procedures

       

ALTER FUNCTION/PROCEDURE name
[NAME newname]
[SQL SECURITY DEFINER/INVOKER]
[COMMENT 'newcomment']








Related examples in the same category

1.Using an OUT parameter
2.Creating a Single-Statement Procedure
3.Calling a Single-Statement Procedure
4.Creating a Multistatement Stored Procedure
5.The ALTER statement lets you change the characteristics of a stored procedure
6.To remove a stored procedures, use the DROP statement
7.Calculate the power in procedure
8.Cleanup table with procedure
9.Compare value in a procedure
10.Output comparison value from a procedure
11.Find out the age with procedure
12.Syntax for Creating store procedures
13.Drop table by procedure