Writing stored procedures of mysql in PHPMYADMIN

1. Open phpMyadmin.
2. Select a database to work with.
3. Open the SQL tab.
4. Select all of the SQL statements between the DELIMITER statements in your stored procedure script. Do not include the DELIMITER statements! Here’s what my example script should look like:

DROP PROCEDURE IF EXISTS spFoo $$
CREATE PROCEDURE spFoo ()
BEGIN
SELECT 'Foo' FROM DUAL;
END $$

5. In the delimiter field, just below the SQL editor’s text area, enter $$ as your delimiter.