[MySQL] Error Code:1175 "Safe update" 해결

 

MySQL에서 UPDATE 사용 시 error code이다. 

 

---

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.

---

1. 일시적 안전 모드 비활성화

SET SQL_SAFE_UPDATES=0; 입력 후 실행

 

2. Message 해결 방법

Edit -> Preferences -> SQL Editor -> Safe Update 해제 -> OK