Tuesday 23 September 2008

Storing a procedure in mySQL

Simple alias for a more complex command...


create procedure nameofmyprocedure () select * from mytable;


To use within mySQL

call nameofmyprocedure();



This assumes that no arguments are required (empty argument list () ).

No comments: