have mysql select statement return fully qualified column names like table.field

Posted by handsomeGun on Stack Overflow See other posts from Stack Overflow or by handsomeGun
Published on 2008-11-06T11:02:08Z Indexed on 2010/04/20 12:43 UTC
Read the original article Hit count: 180

Filed under:
|

is there a way to have a mysql select statement return fully qualified column names like "table.field" without using AS for every single field?

like so:

SELECT * 
FROM  table1  
LEFT JOIN table2 on table1.f_ID = table2.ID

and the result would be: "table1.ID", "table1.name", "table2.ID", "table2.name", ...

© Stack Overflow or respective owner

Related posts about sql

Related posts about mysql