Stored procedures are available in 5.x and later versions of MySQL server. A Stored procedure is a set of SQL commands that 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 procedure instead.
Procedure Editor allows you to create new procedure, execute the existing procedure or edit its definition. It opens automatically when you create a new procedure and is available on editing an existing one.
To open a stored procedure in Procedure Editor, double-click it in the DB Explorer tree.
- Using Navigation bar and Toolbar
- Creating/editing procedure
- Browsing object dependencies
- Editing procedure description
- Specifying input parameters
- Executing procedure
- Viewing DDL definition