连接查询 Error:Column 'XXX' in order clause is ambiguous

最新推荐文章于 2025-05-19 11:38:51 发布

Jysx

最新推荐文章于 2025-05-19 11:38:51 发布

阅读量1.7k

点赞数

CC 4.0 BY-SA版权

文章标签：连接查询

本文链接：https://blog.youkuaiyun.com/weixin_41917449/article/details/82658155

本文解决了一个在使用MySQL时遇到的错误：在连接查询时误将两个表中相同字段当作单表字段，导致Column 'XXX' in order clause is ambiguous。通过在字段前加上表名作为别名来解决此问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

错误为:

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'XXX' in order clause is ambiguous↵

### The error may exist in class path resource [mapper/ClassesSignUpMapper.xml]↵### The error may involve defaultParameterMap↵###

The error occurred while setting parameters

↵### SQL: SELECT * FROM XXX as s1 right join (SELECT * FROM SSS where 1=1 AND name like CONCAT("%",?,"%") )s2 on s1.student_id = s2.id where cls_id = ? order by status asc↵###

Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'XXX' in order clause is ambiguous↵; ]; Column 'XXX' in order clause is ambiguous; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'status' in order clause is ambiguous"