Substituting the table name in the FROM clause by a variable or parameter.
I’ve looked in the MYSQL manuals and forums for this feature. Looks like it doesn’t exist because of security reasons or other.
My thinking: But if this were the case, this could create an excess of procedures in the list of stored procedures in MYSQL where there are DBs with hundreds of different tables. In the other hand, the Front-end that is object oriented and connects to MYSQL would be very inefficient or more complex. The reason is: for called processes that affect any table in the DB that have the same pattern would be individualized for each table an it would congest the list of stored procedures.
Is there any workaround? Help would be greatly appreciated.
Thank you.
Subject
Views
Written By
Posted
Substituting the table name in the FROM clause by a variable or parameter.
3833
October 06, 2005 07:37AM
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.