mysql - 如何更改 INNER JOIN 后收到的列的名称

Question

SELECT  * FROM train 
INNER JOIN station AS s1 ON train.id_station_departure = s1.id 
INNER JOIN station AS s2 ON train.id_station_arrive = s2.id

我想获取name1和name2，而不是name和name。我怎样才能做到？

Answer 1

您需要一个列名别名..但在这种情况下您可以使用 select * ..如果您需要列名别名，则必须使用显式列名

SELECT  s1.name as name1, s2.name as name2
FROM train 
INNER JOIN station AS s1 ON train.id_station_departure = s1.id 
INNER JOIN station AS s2 ON train.id_station_arrive = s2.id