java.sql.SQLException: Data truncation: Truncated incorrect DOUBLE value

mysql 报这个异常：java.sql.SQLException: Data truncation: Truncated incorrect DOUBLE value

 

update 表名 set col1 = ?  and col2 = ? where id = ?

 

改为：

update 表名 set col1 = ?  , col2 = ? where id = ? 用逗号隔开