David Hutchison wrote:
I am new to the list and glad to joining the MySQL community.
I am trying to ascertain the table to which each column in a MySQL
record set belongs in a relational search query. There may well be
duplicate column names across tables.
How can I query MySQL to tell me the
* David Hutchison
> I am trying to ascertain the table to which each column in a MySQL
> record set belongs in a relational search query. There may well be
> duplicate column names across tables.
>
> How can I query MySQL to tell me the parent table for each column in
> the record set? Thanks
Are you working from the mysql command line client? If so you can't. If not what
sort of client are you working with? There isn't much to go on from your description.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
Dear all,
I am trying to ascertain the table to which each column in a MySQL
record set belongs in a relational search query. There may well be
duplicate column names across tables.
How can I query MySQL to tell me the parent table for each column in
the record set? Thanks kindly.
I think you need
I am new to the list and glad to joining the MySQL community.
I am trying to ascertain the table to which each column in a MySQL
record set belongs in a relational search query. There may well be
duplicate column names across tables.
How can I query MySQL to tell me the parent table for each co