mysql - 来自不同表的具有相同名称的列

Question

有如下代码:

SELECT a.*
 , tb_media.filename
 , tb_galleries.name
 , tb_media_iptc.description
 , tb_media_iptc.title
 , tb_media_iptc.headline
 , tb_folders.name
FROM

我对列名称无能为力(不是我的数据库设计)，我如何区分结果中名为“名称”的两个列？

Answer 1

您应该为具有相同名称的任何列提供别名:

SELECT a.*
 , tb_media.filename
 , tb_galleries.name as Name1
 , tb_media_iptc.description
 , tb_media_iptc.title
 , tb_media_iptc.headline
 , tb_folders.name as Differentname
FROM