MySQL Forums
Forum List  »  Microsoft SQL Server

Re: stored procedures
Posted by: Roland Bouman
Date: October 16, 2005 07:25AM

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

Options: ReplyQuote

Written By
October 13, 2005 03:10AM
Re: stored procedures
October 16, 2005 07:25AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.