Stored Procedures and Functions

Stored procedures and functions are a new feature in MySQL 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.

Stored procedures and functions are routines that are created with CREATE PROCEDURE and CREATE FUNCTION statements. A routine is either a procedure or a function.

Database Designer for MySQL helps to build and manage stored procedures and functions in a powerful graphical environment.

Stored functions are the same as stored procedures, except that stored function can return a scalar value. So, the interface for working with them is similar. Tools for stored procedures are universal and work both with procedures and functions.

With Database Designer for MySQL you can:

• Create and Edit stored procedure and function
• Manage all stored procedures and functions within the diagram.

Creating a Stored Procedure or Function | Stored Routine Editor | Stored Routine Manager

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