Debug
[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.
배게
2023. 8. 9. 18:47
728x90
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들이 몽땅 수정이 되버리고 마는데..
이를 방지하기 위함인듯