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.