Re: How to use a tablename as a parameter.
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
Subject
Views
Written By
Posted
3735
March 21, 2005 04:59AM
2508
March 21, 2005 07:35AM
3011
April 13, 2005 09:50AM
Re: How to use a tablename as a parameter.
2614
April 14, 2005 02:31AM
2406
April 14, 2005 02:47AM
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.