作者:LAMP小白 点击:3288 发布日期:2012-10-19 22:07:00 返回列表
ERROR 1052 (23000): Column 'id' in field list is ambiguous
列'ID'在字段列表中重复
刚开始,没仔细看以为是我打错了字母了,后来发现其实是查询的两张表里面都有个叫'id'的字段,而我敲的时候又没有指定是那张表的id
所以在数据列前面加上表名是个好方法,可以避免这种问题
如
mysql> SELECT student.name, student.student_id, score.score FROM student INNER JOIN score ON student.student_id = score.student_id WHERE student.name='mio';
+------+------------+-------+
| name | student_id | score |
+------+------------+-------+
| mio | 1 | 99 |
| mio | 1 | 77 |
| mio | 1 | 88 |
| mio | 1 | 99 |
+------+------------+-------+
4 rows in set (0.00 sec)
上一篇:www-authenticate认证 下一篇:快递查询API