当执行下面的 SQL 查询时:
UPDATE shop_category
SET name = 'Secolul XVI - XVIII'
AND name_eng = '16th to 18th centuries'
WHERE category_id = 4768
以下错误被引发:1292 - Truncated incorrect DOUBLE value: 'Secolul XVI - XVIII'
如何修复这个问题?
shop_category
表结构:
category_id mediumint(8)
name varchar(250)
name_eng varchar(250)