Stored Procedures and myPHPadmin
I admin a MySQL database for a family website on a commercial web server and my only access to the base is via myphpadmin.
Professionally I'm an Oracle PL/SQL developer and use a telnet session to connect and run my scripts, which makes life a ton easier.
The web server uses MySQL 5.0 which supports stored procedures but every time I try to run a script by either importing them or cut and pasting on the SQL window I get an 1064/5 error.
I created a MySQL database on my own machine, setup myphpadmin and still cannot run 'create procedure' script.
Has anyone successfully created a stored procedure on a MySQL database using myphpadmin? And, if so, HOW?