How do I write an SP in phpMyAdmin (MySQL)?
In phpMyAdmin you can create the stored procedure in the SQL window.
You may have to set the delimieter to something like "$$" instead of the default ";". You can change this from the bottom of the SQL window.
Copied from the internets:
The answer is yes and no. Phpmyadmin has no tools for creating stored procedures but you can enter in SQL using it and in that way create them.
(Note I don't believe versions prior to MySQL 5 supported stored procedures.)