Supporting Features Added in MySQL 5 - Mastering phpMyAdmin 3.4 for Effective MySQL Management - page 292

Manipulating procedures and functions
A procedure is stored inside a database, and is not tied to a specific table. Therefore,
the interface for manipulating procedures and functions can be found at the database
level, on the Structure page under the Routines slider, which appears if at least one
routine is already defined.
The first icon brings this procedure's text into a query box for editing. The second
icon would be used to delete this procedure. When editing the procedure, we notice
that the text has been somewhat modified.
DROP PROCEDURE `add_page`//
CREATE DEFINER=`marc`@`%` PROCEDURE `add_page`(IN param_isbn
VARCHAR(25), IN param_pages INT, OUT param_message VARCHAR(100))
BEGIN
IF param_pages > 100 THEN
SET param_message = 'the number of pages is too big';
ELSE
UPDATE book SET page_count = page_count + param_pages WHERE
isbn=param_isbn;
SET param_message = 'success';
END IF;
END
First, a DROP PROCEDURE statement appears. This is normal because MySQL does not
offer a statement that would permit changing the body of a procedure. Therefore, we
have to delete a procedure every time we want to change it. It's true that the ALTER
PROCEDURE statement exists, but it can only change the procedure's characteristics,
for example, by adding a comment. Then, a DEFINER clause is shown. It was
generated at creation time, and indicates who created this procedure.
At this point, we make any changes we need to the code, and click on Go to save
this procedure.