Re: stored procedures

[Roland Bouman]

You need to be more specific (does have to be a table in particular, is is if for any arbitrary table; do you mean database or MySQL server instance? databases and schmas are equivalent in MySQL) to get a good answer. But
1) MySQL 5 supports stored procedures
2) In a stored procedure, you can have SELECT statement
3) To select all fields from a table, do: SELECT *
4) To refer to a table with the name T in the schema S, use: S.T
5) You can use dynamic SQL as of MySQL 5, so you can do it for arbitrart schemas and arbitrary tables.

So, At a glance, it appears that you could in MySQL 5