Procedure Designer

The Procedure Designer is provided for creating and altering MySQL stored procedures. To design a new procedure double-click the Create procedure in design view item within the Profile Window | Procedures page. To design the existing procedure select its name within the Profile Window | Procedures page and click the Design button on the toolbar or in the popup menu.

Note, that stored procedures are available only for MySQL 5.0 or higher.

The Procedure Designer window provides two pages for designing the procedure. The Main tab allows you to modify the list of procedure parameters by specifying name, kind (IN, OUT, INOUT) and data type for each parameter. The Options tab allows you to edit the procedure name, comment, and security type.

The Parameters list contains the list of all procedure parameters. To add a new parameter simply proceed to the first empty node and fill in the cells. The Procedure Body text edit represents the procedure text, which appears between BEGIN and END SQL keywords in the CREATE PROCEDURE statement. Note, that you can easily insert procedure parameters into the body text by dragging the list nodes onto the edit area.

The Options tab allows you to define the procedure name, comment, and security type.

The Security Type option can be used to specify whether the routine should be executed using the permissions of the user who creates the routine or the user who invokes it. The default value is DEFINER. The creator or invoker must have permission to access the database with which the routine is associated.

All changes made to the procedure design takes effect only after the Apply button is pressed. If you want to discard all changes and revert to the last saved procedure design, click Revert.