MySQL alias shorthand?
alias, mysql
Solution
No, you'll need to name them explicitly.
Problem
I need to select all columns from two tables, but need to be able to differentiate between them in the result. Is there a shorthand method of giving each column in the result an alias? For example: ``` SELECT t1.* AS t1.SOMETHING , t2.* AS SOMETHING_ELSE FROM TABLE1 INNER JOIN TABLE2 ON SOMETHING = SOMETHING_ELSE ``` In the results, all columns from table one would be prefixes t1, while all results from table two would be prefixes t2. Any advice appreciated. Thanks.