Online Documentation for SQL Manager for MySQL

Stored Functions

Stored functions are routines that are available in 5.x and later versions of MySQL server. A Stored function is a set of SQL commands that returns the result and can be stored in the server. Once this is done, clients do not need to keep re-issuing the individual commands but can refer to the stored function instead.

Function Editor allows you to define function properties. It opens automatically when you create a new function and is available on editing an existing one.

To open a function in Function Editor, double-click it in the DB Explorer tree.

• Using Navigation bar and Toolbar
• Creating/editing function
• Browsing object dependencies
• Editing function description
• Viewing DDL definition
• Executing function