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

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

改为:

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

05-11 11:23