MySQL别名的缩写? [英] 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?

例如:

SELECT t1.* AS t1.SOMETHING
     , t2.* AS SOMETHING_ELSE 
  FROM TABLE1 
 INNER JOIN TABLE2 
    ON SOMETHING = SOMETHING_ELSE

结果中，表1的所有列都将以前缀t1为前缀，而表2中的所有结果将以前缀t2为前缀.

In the results, all columns from table one would be prefixes t1, while all results from table two would be prefixes t2.

任何建议表示赞赏.

谢谢.

推荐答案

否，您需要明确命名它们.

No, you'll need to name them explicitly.

这篇关于MySQL别名的缩写?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！