How to return a table from Stored Procedure in MySql?

Question

i found my answer in sql server at here, but my question is about in mysql. please help me

Answer 1

well to create a stored procedure in mysql you do it like so...

delimiter //;
create procedure Foo()
BEGIN
Select * from videos;
END

See http://dev.mysql.com/doc/refman/5.0/en/create-procedure.html for additional details