[MySQL] You are using safe update mode and you tried to update a table ..

카테고리 없음 2018. 4. 30. 12:40
반응형

아래와 같은 오류가 나면, 

update safe mode 이다. 


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. 0.016 sec



SET SQL_SAFE_UPDATES =0;


를 해주면 풀린다.

반응형
: