mysql query add [something]_ infront of all table rows when grabbing multiple tables

Question

Example of what I want to do: select a.* as a_, b. as b_* FROM a, b WHERE a.id = b.id

Answer 1

Cannot be done automatically in SQL. Either type or generate the following:

SELECT a.field AS a_field, a.field2 AS a_field2, ...

At any rate, listing the fields by hand is good practice anyways.