[Error] Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column

delete from 테이블명;

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.

삭제 쿼리를 실행하니 다음과 같은 에러가 뜸

 

 

✨ 해결

where 없이 다 삭제할 때 

1. Safe Updates (rejects UPDATEs and DELETEs with no restrictions) 체크 해제

2. workbench 다시 시작

3. 삭제 쿼리 다시 실행하면 잘 된다.

 

 

참고 👇

https://lightblog.tistory.com/193

[MYSQL] 에러 번호 1175 Safe Update 해결방법