Mysql can not delete data

Sheng-Shan Chen
Apr 16, 2021

--

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.

Just use below code

SET SQL_SAFE_UPDATES=0;
# SQL statement
SET SQL_SAFE_UPDATES=1;

--

--