Question

数据库查询时连接2个表查询，遇到2个表中字段重名怎么办？

表 stutent(name,id) 1：n cource(name,id,student_id)2个表是一对多关系对这2个表连接查询 select * from student,course where student.id=course.student_id这样查询后的字段重名该怎么读取结果呢？

Answer 1

你可以使用别名进行分辨，比如这样写连接查询 select course.name as course ,course.id as courseid , student.name as studentname ,student.id as studentid from student,course where student.id = course.student_id