column 'id' in field list is ambiguous
这个错误,是因为你查询语句里面有id字段的时候,没有说明是哪个表的id字段,应该加上表名(或者别名)来区分。 用表名进行区分的例子:
select student.id, student.name, score.total
from student, score
where student.id = score.id
mysql> create view com
-> as
-> select test.id,test.age
-> from test,users
-> where test.id=users.id;