언어/MySQL

You are using safe update mode and you tried to update a table without

Mustang 2012. 11. 30. 12:51

Error Code: 1175
You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
Every found that kind of error when trying to update rows in mysql? It’s because you tried to update a table without a WHERE that uses a KEY column (err …).

MySQL을 설치하고 Update나 Delete명령문을 실행할 때 1175번 에러가 나는 경우가 있다. 이럴경우엔

Workbench에서 Edit->Preferences->SQL Queries에서 "Safe Updates". Forbid UPDATEs and DELETEs with no key in WHERE clause or no LIMIT clause. .....이 항목의 체크를 풀어주고 Workbench를 재실행 시켜주면 된다.