[MySQL] UPDATE時出現Error Code: 1175

Error Code: 1175 You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

百思不得其解update語法哪裡有錯==

原來是workbench的關係

解法：

Edit→Preferences

[SQL Editor]

勾掉[Forbid UPDATE and DELETE statements without a WHERE clause (safe updates)]

 [OK]

 重開Workbench(不然沒效)