Stored Functions

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.

A function can be called from inside a statement just like any other function (that is, by invoking the function's name), and can return a scalar value.

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

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

To execute the existing function and view its result, simply double-click at its name on the Functions profile window page.

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

To delete a function from the database, select its name at the Functions 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.