Duplicate column name ‘id’
重复列名“id”
第一种
create view student_class_v1 AS
select s.*,c.id as cid ,c.name
as cName from my_class c left join
my_student2 s on c.id=s.class_id;
select * from student_class_v1
第二种
create view student_class_v1 AS
select * from my_class right JOIN
my_student2
using(id,name);
数据库列名重复
最新推荐文章于 2023-04-19 11:41:25 发布