How to write a stored procedure in phpMyAdmin?

Question

I am not able to find where to write the stored procedure in phpMyAdmin and how to call it using MVC architecture.

Answer 1

You can easily create procedures in phpMyAdmin.

1. Go to your database. Click 'Routines' tab in header
2. Click on 'Add routine'

3. Then a popup window will be opened. In that write your procedure and click on "GO"

For example like follows.

That's it. You can view your created procedures under 'Routines' tab itself.