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