MySQL 报错 have an error in your SQL syntax; check the manual that corresponds to your MySQL serve

all_sale_deduct_f = 2, WHERE `id`=1

这里，WHERE前面最后一个字段后面，只能有空格，不能有逗号了

改成这样 all_sale_deduct_f = 2 WHERE `id`=1

运行cmd，进入mysql安装目录，重新安装mysql server：

mysql/bin>mysqld -remove

mysql/bin>mysqld -install

mysql/bin>mysql_config_editor.exe set -u root -p

---