Truncated incorrect DOUBLE value

报错提示：

> 1292 - Truncated incorrect DOUBLE value: '1,'

原因：

update device set type = REPLACE(type, '2', '') where type = 2;
type 类型为varchar，需要改为
update device set type = REPLACE(type, '2', '') where type = ’2‘;
字段类型应保持一致