[phpmyadmin] stored procedure and trigger

查看目前已建立的stored procedure
show procedure status

查看目前已建立的stored procedure

select * from information_schema.routines where routine_type = 'procedure'

查看指定資料庫內已有的stored procedure

select * from information_schema.routines where routine_type = 'procedure' and routine_schema = 'your_db'

新建stored procedure

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.

Reference:
如何使用MySQL的Stored Procedure與Trigger
Using phpMyAdmin to Create Stored Procedures