### The error may involve com.heima.mapper.CustomerMapper.updateCustomer-Inline
### The error occurred while setting parameters
### SQL: update customer SET cust_name = ? cust_source = ?, cust_industry = ?, cust_level = ?,
`cust_linkman` = ?, `cust_phone` = ?, `cust_mobile` = ?, `cust_zipcode` = ?,
`cust_address` = ? where cust_id = ?
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version for the right syntax to use near 'cust_source = '6',
update customer SET cust_name = ? cust_source = ?, cust_industry = ?, 。。。。。
cust_name = ? ,后面少了逗号
原因，map.xml中少了括号
### The error may involve com.heima.mapper.CustomerMapper.updateCustomer-Inline### The error occurred while setting parameters### SQL: update customer SET cust_name = ? cust_source...
今天创建表，在执行insert句语时，my
Sql
报错
了
Transla
ting
SQLException
with
SQL
state
'
42000
',
error
code
'
1064
' 。
建表语法：
CREATE TABLE `app_sms_t` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`mobile` va...
遇到一个
sql
更新语句异常，提示
state
‘
42000
’，
error
code
‘
1064
’。
因为项目是ssm，利用mybatis逆向工程生成的mapper和pojo文件，要更新的这个表中有新加的字段，但是在mapper.xml中这个字段在添加的时候，未在后方加‘，’导致语句错误。
今天无意中重启项目之后出现问题：
[2021-08-17 15:55:48,511] [WARN ] [org.hibernate.engine.jdbc.spi.
SqlException
Helper 137] [] traceLogid:[]【】dstTraceId:[]
SQL
Error
:
1064
,
SQL
State
:
42000
[2021-08-17 15:55:48,512] [
ERROR
] [org.hibernate.engine.jdbc.spi.
SqlException
Helper 1
@Controller
List<PubUserProject> pubUserProjects = userProjectService.getUserProjectInfo(f);
int updateAllCount = userP...
public boolean equals(Object obj) {
if (obj instanceof Integer) {
return value == ((Integer)obj).intValue();
return false;
equals比较两个不同类型的数据值是否相等
循环执行数据，出现异常跳过，继续执行下一条
丿梁上君子:
DateConverter does not support default String to 'Date' conversion.
weixin_45034448:
