|
Procedure/Function Overview
|
Previous Top Next |
Procedures and Function is a new addition to MySQL 4 and MyCon allows you to view, add, update, rename and delete procedures and functions on your MySQL. Procedures and Functions gets listed either below your root connection folder's Procedures folder, or if the procedures and functions are specific to a database, MyCon also list the database specific procedures below your Database/Procedures folder. As can be seen in the picture two types of icons are show, one for functions and one for procedures. Using your Folders pane, you can add, drop and rename procedures and functions by just simply selecting the specific procedure or function and rightclicking on it to get the pop up menu (or rightclicking on the Procedures folder if you want to add a function or procedure). It is generally understood that you have to write a new procedure or function first (see your MySQL Manual for the format and SQL to create a new procedure or function), you can however use your Script or Query editors to accomplish and develop your procedures and functions, when you are finished save your SQL to a file and right click the Procedures folder. Click Add and specify a name for your procedure or function, you will be prompted to confirm and then be prompted for your procedure/function creation SQL file.