SQL查询中的列名称重复 [英] Duplicate column names in SQL query

问题描述

在两个具有相同列名的表上创建VIEW时，如何避免MySQL中的dup列名错误

How do I avoid a dup column name error in MySQL when creating a VIEW on two tables that both have the same column name as shown here

CREATE VIEW db.VI_RegionCity AS SELECT
    Region.Name,
    City.Name
FROM
    db.Region Region,
    db.City City
WHERE
    Region.RegionCode = City.RegionCode



ERROR: Duplicate column name 'Name'

推荐答案

为列名使用别名

CREATE VIEW db.VI_RegionCity AS SELECT
    Region.Name as Region_name,
    City.Name as City_name
...//rest of the query

这篇关于SQL查询中的列名称重复的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！