Substituting the table name in the FROM clause by a variable or parameter.

[Michael A. Rivas Evans]

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.