Function Designer

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

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

The Function Designer window provides two pages for designing the function. The Main tab allows you to modify the list of function parameters by specifying name and data type for each parameter. The Options tab allows you to edit the function 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 Function Returns drop-down list allows you to select the result data type for the function. The Function Body text edit represents the function text, which appears between BEGIN and END SQL keywords in the CREATE FUNCTION statement. Note, that you can easily insert function parameters into the body text by dragging the list nodes onto the edit area.

The Options tab allows you to define the function 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 function design takes effect only after the Apply button is pressed. If you want to discard all changes and revert to the last saved function design, click Revert.