I want to be able to create stored processes using phpMyAdmin
and later it will be php I want to use it through
But I do not know how?
Whatever I know, I have found that we can not manage stored procedures through phpMyAdmin
.
I'm also not sure that this is a better option for using stored functionality via PHP. Any suggestions?
Since using a stored procedure, you can actually use them phpMyAdmin Asks.
To create a stored procedure, you can use the following (changes as needed):
created process sp_test () Number of records: 'From the test ( *) Calculation; END //
And make sure you set the "Delimiter" field on the SQL tab. //
Once you create a stored procedure, it's the routings field under your tables (in the Structure tab), and you can easily change / drop it.
To use PHP stored procedure, you have to execute the call query, as you would in plain SQL.
Comments
Post a Comment