[MySQL] Error Code 1175

delete 명령어로 행을 지우려고 할때 발생합니다.

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.

 

쿼리로 safe update mode 해지 후 사용하면 됩니다.

SET SQL_SAFE_UPDATES=0;