department的mysql缩写_MySQL别名的缩写？

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.

解决方案

No, you'll need to name them explicitly.