MySQL Error Code: 1175. safe update mode update a table without a WHERE

Dung Do Tien Nov 08 2021 108

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.

Error Code: 1175. safe update mode update a table without a WHERE

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.
  • M

    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.

Related Q&A May You Like

  1. MySql throw no database selected, select the default DB to be used by double-clicking its name
  2. How to generate whole sql database script in MySql Workbench
  3. Error querySrv ENODATA _mongodb._tcp.456d in MongoDB Compass
  4. What is best way to convert datetime to date in Sql Server?
  5. How to compare date without time with now() in PostgreSQL?
  6. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements in MySQL
  7. ERROR: column must appear in the GROUP BY clause or be used in an aggregate function in PostgreSQL
  8. Calculating distance between two positions(lat, long) in SQL Server
  9. MySQL Error: 'Access denied for user 'root'@'localhost'
  10. Error: /opt/lampp/bin/mysql.server: 264: kill: No such process
  11. How to get the total of current connection in PostgreSQL?
  12. How to backup and restore MSSQL Server database in Ubuntu
  13. ERROR: OFFSET must not be negative in PostgreSQL
  14. How to update top N records for a table in PostgreSQL?
  15. PostgreSQL Error: Terminating connection due to administrator command
Leave An Answer
* NOTE: You need Login before leave an answer

* Type maximum 2000 characters.

* All comments have to wait approved before display.

* Please polite comment and respect questions and answers of others.

Most Quizs Popular

Start Test

Javascript - Functions

Start Test

Asp.Net Core - Exam test 01

Start Test

Asp.Net Core - Exam test 02

Start Test

C# - Level Beginner

Popular Tips

This site uses cookies so that we can remember you and understand how you interact with our website. This allows us to improve and customize your browsing experience. See our Cookies Policy.
X Close