mysql存储过程编程pdf mysql8.0存储过程

使用如下命令可以查看数据表的存储过程

mysql>SELECT ROUTINE_TYPE, ROUTINE_NAME
    FROM INFORMATION_SCHEMA.ROUTINES
    WHERE ROUTINE_SCHEMA='dbname';

 +--------------+----------------+
| ROUTINE_TYPE | ROUTINE_NAME   |
+--------------+----------------+
| PROCEDURE    | continueinsert |
| PROCEDURE    | insertdata     |
+--------------+----------------+
2 rows in set (0.00 sec)