UPDATE shop_category SET name = ‘Secolul XVI - XVIII‘ AND name_eng = ‘16th to 18th centuries‘ WHERE category_id = 4768
category_id mediumint(8) name varchar(250) name_eng varchar(250)
执行报错
1292 - Truncated incorrect DOUBLE value: ‘Secolul XVI - XVIII‘
问题原因，update不应该用and，修改sql语句为
UPDATE shop_category SET name = ‘Secolul XVI - XVIII‘, name_eng = ‘16th to 18th centuries‘ WHERE category_id = 4768
mysql修改Truncated incorrect DOUBLE value:
原文：https://www.cnblogs.com/dashuai01/p/8978073.html