运行时出现错误
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column ‘bitch’ in ‘field list’
错误原因：
我的sql语句的列名写错误了
数据库是这样的
我写的sql是
String sql = “insert into customers(name,email,bitch)value(?,?,?)”
birth写成了bitch
改过后运行
相关文章
- 10-04错误代码： 1054 Unknown column 'course' in 'field list'
- 10-04数据插入异常，原因是: (1054, "Unknown column '\ufeff95001' in 'field list'")
- 10-04报错处理：java.sql.SQLSyntaxErrorException: Unknown column ‘草莓‘ in ‘field list‘
- 10-04Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'name' in 'field list
- 10-04Unknown column 'startname' in 'field list
- 10-04springboot 报错 sprintgboot Unknown column '字段名' in 'field list'
- 10-04Caused by: java.sql.SQLSyntaxErrorException: Unknown column 'name' in 'field list'
- 10-04django.db.utils.InternalError: (1054, "Unknown column 'cid' in 'field list'")
- 10-041054 Unknown column 'emaile' in 'field list' 如果网上的方法都试过了没用的话
- 10-04django报错：(1054, "Unknown column 'blog_readnum.blog_id' in 'field list'"