Procedure/Function Overview
Previous  Top  Next

procfoldersProcedures 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. led-triangle-amber You need special MySQL Security privileges to be able to add/modify/delete procedures and functions.

proc
Now that you have your procedure/function added you can just Open it from the right click menu and be presented with a full Grid View of all your procedures and functions (or just one depending if you opened a specific procedure or function or if you Opened the Procedures folder). Here you can edit, update and even delete your procedures and functions.