com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'e.title' in
来源:互联网 发布:编程靠天赋 编辑:程序博客网 时间:2024/05/22 13:41
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'e.title' in
[ERROR]
com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred while applying a parameter map.
--- Check the studentExam.getList-InlineParameterMap.
--- Check the statement (query failed).
--- Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'e.title' in 'field list'
====================================================================================================
这个错误是在使用ibatis时抛出的。
原因是 e(这是别名) 这张表中,没有 title 这个字段。
解决方法:
检查 sql语句中 表名是否写对,
检查 sql语句中 表里面的字段名是否写对。
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'e.title' in
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'password' in
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column
- Hibernate com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'password' in
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'cname' in 'where clause'
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ""in 'field lis
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column '?°?????±±???' in 'field l
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'XXX' in 'whe
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'rtjhyt' in 'field list'
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'XX' in
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column dd in where clause
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'orderdetail.id' in 'fiel
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'id' in 'order clause'
- com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'typeId' in
- com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column '????' in
- Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 't.statis_date'
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'user'
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown database 'smvch'
- [Leetcode] Implement strStr()
- Win_Eclipse Dev
- 工作满三年,Mark
- C# WinForm窗体及其控件的自适应
- 常见网络传输协议
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'e.title' in
- 程序员不要做沙和尚
- jsp中中文出现乱码的原因及解决方案(Java中Unicode、编码的理解)
- 考察二进制知识
- Android深入浅出之Binder机制
- 系统生成与系统启动
- 使用SQLCMD在SQLServer执行多个脚本
- @Autowired的用法
- MAVN 相关的XML