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
3981
March 21, 2005 04:59AM
2679
March 21, 2005 07:35AM
3153
April 13, 2005 09:50AM
Re: How to use a tablename as a parameter.
2782
April 14, 2005 02:31AM
2537
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.