Create and Execute Stored Procedure in PHPMyAdmin
This post will cover how to create Stored Procedures using PHP My Admin. Next part will cover how to execute Stored Procedures using Laravel.
Published in
2 min readAug 2, 2018
First of all what is Stored Procedure?
A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again.
You can pass parameters to the stored procedure to get data based on Dynamic values.
Step -1 : Open PHP My Admin and select the database to create stored procedure
Step -2 : Go to Routines menu & Click on Add routine.
Step -3 : By Clicking on Add Routine Link, PHPMyAdmin will open Pop-up.
Step -4 : Follow the steps and create stored procedure.Create stored procedure to get data from users table( Without Parameters) .
