报错提示：
> 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‘;
字段类型应保持一致
标签：incorrect,set,Truncated,DOUBLE,value,type From： https://www.cnblogs.com/wongzzh/p/16966382.html