且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

PHP/MySQL:在无别名的联接查询中获取多个同名列?

更新时间:2023-02-23 22:55:23

我觉得在这种情况下别名是完美的

I think alias is perfect in this case

SELECT table1.column AS column1, table2.column AS column2
FROM table1
LEFT JOIN table2
ON table1.column = table2.column

为了节省一些打字时间,请使用表格别名:

To save you some typing time, use table aliases:

SELECT t1.column AS column1, t2.column AS column2
FROM table1 AS t1
LEFT JOIN table2 AS t2
ON t1.column = t2.column