[MySQL] Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.

Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column.  To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.

 

해결방법 

- editor - preferences - SQL editor - safe Updates 체크해제

 

 

 

 

WHERE절 안쓰고 UPDATE하면 DB의 row들이 몽땅 수정이 되버리고 마는데..

이를 방지하기 위함인듯