MySQL Error Code: 1175. safe update mode update a table without a WHERE
Dung Do Tien
Nov 08 2021
95
Hello Guys,
I have a MySQL server and I have created a impression
table. I want to update the value of numberofvisit
column to 0:
update impresssion set numerofvisit = 0
I ran the above command and I got an exception Error Code: 1175. safe update mode updates a table without a WHERE.
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.
My table has 12k records. I don't know why it's not allowing me to update it.
Thanks for any suggestions.
Have 1 answer(s) found.
-
M0
MRIDUAVA মৃদুআভা Nov 08 2021
You can use the command below to help change the setting default in the MySQL database:
Like this:
-- disable safe update mode SET SQL_SAFE_UPDATES=0; -- execute update statement UPDATE table SET column='value'; -- enable safe update mode SET SQL_SAFE_UPDATES=1;
FOR an example:
-- disable safe update mode SET SQL_SAFE_UPDATES=0; -- execute update statement UPDATE impresssion SET numerofvisit = 0 -- enable safe update mode SET SQL_SAFE_UPDATES=1;
I hope it works for you.
* Type maximum 2000 characters.
* All comments have to wait approved before display.
* Please polite comment and respect questions and answers of others.