如何使用PHP从具有多个同名列的MySQL行中获取结果? [英] How to fetch result from MySQL row with multiple same-name columns with PHP?

问题描述

select * from A left join B on A.columnc=B.columnd

上述SQL返回的结果将同时包含A和B列.

results returned by above SQL will include both columns of A and B.

如果A和B的某些列具有相同的名称怎么办?

And what if A and B have some columns with the same name?

如何从PHP检索值?

推荐答案

您可能希望在查询中更加明确.这样，您可以为列提供别名:

You probably want to be more explicit in your query. That way you can provide aliases for your columns:

SELECT
  A.foo as a_foo,
  B.foo as b_foo
FROM A
LEFT JOIN B ON A.columnc = B.columnd

这篇关于如何使用PHP从具有多个同名列的MySQL行中获取结果?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！