mysql - 更新列时出现语法错误

Question

我正在尝试使用以下代码来更新列:

UPDATE user_profiles 
    SET range = '20', colResize = 'flex' 
    WHERE uid='472';

我收到以下错误:

Failed to execute SQL : SQL UPDATE user_profiles SET range = '20', colResize = 'flex' WHERE uid='472'; failed : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range = '20', colResize = 'flex' WHERE uid='472'' at line 1

我忽略了什么？

Answer 1

范围是 reserved keyword in MySQL 。使用反引号转义名称或使用其他列名称。

SET `range` = 20