mySql workBench error code 1175 safe mode 해제하기

MySql에서 다음과 같은 쿼리문에 대한 SafeMode 블록이 걸릴때,

14:11:13 delete from dprc_rto where DPRC_RTO_SEQ like 23

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

아래와 같이 수행하면 됩니당~

SET SQL_SAFE_UPDATES = 0;

delete from dprc_rto where DPRC_RTO_SEQ like 23;

SET SQL_SAFE_UPDATES = 1;

SET SQL_SAFE_UPDATES = 0;

delete from dprc_rto where BIZTYPE_CAT like '%2%';

SET SQL_SAFE_UPDATES = 1;