MySQL error code: 1175 during UPDATE in MySQL Workbench

 

方法1:

MySQL Workbench ->Edit -> Preferences -> SQL Edit

去掉 Safe update 的勾选项, 保存。 然后关掉MySQL Workbench ,再重新打开。

 

方法2:

SET SQL_SAFE_UPDATES = 0;

# your code SQL here

SET SQL_SAFE_UPDATES = 1;

Leave a Comment