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

Question

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", ...

Answer 1

If you are using PHP you can use PDO to get this result.

$PDO->setAttribute(PDO::ATTR_FETCH_TABLE_NAMES, true);

See SQL Select * from multiple tables for more information.

Answer 2

Not really. You could write some dynamic SQL to accomplish this, but it wouldn't be simple. If you really want the dynamic SQL, let me know and I could try to whip something up.