CODEWITHSUNDEEP
mysqlalias
Dan
Dan

Reputation: 4150

MySQL alias shorthand?

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.

Upvotes: 4

Views: 1005

Answers (2)

Andy
Andy

Reputation: 17791

No, ALIAS is only for single columns. The only shorthand is to remove the AS:

SELECT column_123 col FROM x

Returns col as the alias.

Upvotes: 3

Quassnoi
Quassnoi

Reputation: 425833

No, you'll need to name them explicitly.

Upvotes: 3

Related Questions