It took a while before phpMyAdmin started to include support for stored procedures and functions. The reason is that these features are blocks of code (like a subprogram) that are kept as a part of the database, and phpMyAdmin, being a web interface, is more oriented towards operations that are performed quickly using a mouse.
Nonetheless, phpMyAdmin has a few features that permit a developer to create such routines, save them, recall them to make some modifications, and delete them.
Procedures are accessed by a
CALL statement to which we can pass parameters. On the other hand, functions are accessed from SQL statements (for example,
SELECT), similar to other MySQL internal functions returning ...