Say I have two tables, and they have several column names that are the same in both tables. I know I can manually alias the column names so that they don't overlap, but is there a way to prefix *all* of the columns of one table so that I can be sure the names don't overlap?
So if I have these two tables: person: id,name,age,home_id place: id,name,zip_code then I could use a query like: SELECT person.*,place.* as home_* FROM person,place WHERE person.home_id = place.id AND name = 'Joe' To get back results like: id,name,age,home_id,home_name,home_zip_code The problem is that I don't want to have to update my queries everytime I add a new column, so I use table_name.* a lot. But then if I ever add a column with the same name to another table, I will only get one column or the other back. Does MySQL do this? Should it? - Isaac -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
