java - 错误:com. mysql.jdbc.MysqlDataTruncation:数据截断:截断不正确的DOUBLE值:通过删除

Question

我有这个代码:

bb.doCammand("delete  from models where model_id='" + del + "' OR model_name='" + del + "'");

我收到此错误:

Error:com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: xd model_id and model_name are string.

如何解决？

Answer 1

您的查询中似乎存在拼写错误。

假设 del 是一个 String 变量，尝试更改与此展示相关的查询:

"DELETE from models WHERE model_id =" + del + " OR model_name =" + del

最好避免在查询末尾进行串联。