MYSQL截断了错误的DOUBLE值

MYSQL截断了错误的DOUBLE值

您不需要

AND

关键字。这是UPDATE语句的正确语法：

UPDATE     shop_category SET     name = 'Secolul XVI - XVIII',     name_eng = '16th to 18th centuries' WHERe     category_id = 4768