[ MYSQL ] WHERE 를 통한 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 모드 비활성화

set sql_safe_updates=0;

 

작업후 다시 Safe 모드를 활성화 시켜놓을 것

set sql_safe_updates=1;