Creating a Single-Statement Procedure : Procedure « Procedure Function « MySQL Tutorial






  1. MySQL Tutorial
  2. Procedure Function
  3. Procedure
mysql>
mysql>
mysql> create procedure myProc ()
    ->   SELECT id,first_name FROM employee;
Query OK, 0 rows affected (0.00 sec)

mysql>
mysql> call myProc ();

mysql>
mysql> drop procedure myProc;
Query OK, 0 rows affected (0.00 sec)








11.5.Procedure
11.5.1.The CREATE PROCEDURE Statement
11.5.2.You can set parameters for a stored procedure
11.5.3.Using an OUT parameter.
11.5.4.The stored procedure characteristics include a number of options for how the stored procedure behaves.
11.5.5.Creating a Single-Statement Procedure
11.5.6.Calling a Single-Statement Procedure
11.5.7.Creating a Multistatement Stored Procedure
11.5.8.The ALTER statement lets you change the characteristics of a stored procedure
11.5.9.To remove a stored procedures, use the DROP statement
11.5.10.ALTER PROCEDURE and ALTER FUNCTION Syntax
11.5.11.DROP PROCEDURE and DROP FUNCTION Syntax
11.5.12.Stored Procedure Permissions