I don't Mysql very well, but I would be very surprised if that was
supported, based on my experience with Oracle. You need to distinguish
between data and database object names. You can use derived_tables to return
data, but niot names.
You can't do " select * from 'table'", because 'table' is a s
Are you trying to do this within a programming language? I use similar
queries using PHP and have no problem. Although I would write my query
like:
SELECT tbl_name FROM user_table WHERE user = 'guy';
And then use the result to run a select, update, insert, or whatever
-Dan
On Sun, 2003-07-13
