Stored Procedures

Stored procedures and functions are a new feature in MySQL version 5.0. A stored procedure is a set of SQL statements that can be stored in the server. Once this has been done, clients don't need to keep reissuing the individual statements but can refer to the stored procedure instead.

The list of database procedures can be viewed and modified at the Procedures Page of the Main Profile Window.

You can create a new procedure in Design View by double-clicking at the Create procedure in design view item on the Procedures profile window page.

To execute the existing procedure and view the value of the output procedure parameters, simply double-click at its name on the Procedures profile window page.

To change the procedure structure select its name at the Procedures page and click the Design button on the toolbar or in the popup menu. This opens the Procedure Designer, allowing you to edit procedure parameters, body, etc.

To delete a procedure from the database, select its name at the Procedures page and click the Delete button on the toolbar or in the popup menu.

©2004 MicroOLAP Technologies LTD. All Rights Reserved. All trademarks are the sole property of their respective owners.