mysql ERROR 1292 (22007): Truncated incorrect DOUBLE value 问题

mysql> update category set sequence=4  where company_id=94588133873178  and id=669302535743868015;
ERROR 1292 (22007): Truncated incorrect DOUBLE value: 'B85F63B64E5930118D1C07993374BB60'

查看表结构后

 CREATE TABLE `category` (
  `id` varchar(50) NOT NULL,
  `company_id` varchar(50) NOT NULL,
  `created_by` varchar(50) DEFAULT NULL,
  `created_time` datetime DEFAULT NULL,
  `last_modified_by` varchar(50) DEFAULT NULL,
  `last_modified_time` datetime DEFAULT NULL,
  `name` varchar(50) NOT NULL,
  `depth` int NOT NULL,
  `type` varchar(10) NOT NULL,
  `parent_id` varchar(50) DEFAULT NULL,
  `level1_name` varchar(50) DEFAULT NULL,
  `level2_name` varchar(50) DEFAULT NULL,
  `level3_name` varchar(50) DEFAULT NULL,
  `level4_name` varchar(50) DEFAULT NULL,
  `sequence` int DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 

因为公司id 以及 id 数据库中定义的是varchar 导致的问题.

加上引号就解决了.

 update category  set sequence=3  where company_id='94588133873178' and id='402498172257099776';