MySQL Forums
Forum List  »  Stored Procedures

Re: How to use a tablename as a parameter.
Posted by: Andrew Gilfrin
Date: April 14, 2005 02:31AM

I think it all boils down to the way the statement will be compiled and parsed. MySQL needs to know upfront what it's going to need to look for.

In other langauges this is dealt with special commands in the procedural element of the language, for example DBMS_SQL in older versions of Oracle and Execute Immediate in 8i and up.

It could be useful but the problem with it would be performance. If your looking for a general select anything from any table procedure you may as well implement this in your calling program rather than MySQL.

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to use a tablename as a parameter.
2614
April 14, 2005 02:31AM


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.