Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (22.5k points)
edited by
I tried to update the column visited to give it the value 1.

UPDATE tablename SET columnname=1;

Error:

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

1 Answer

0 votes
by (11.1k points)
edited by

Instead of

UPDATE tablename SET columnname=1;

try this

SET SQL_SAFE_UPDATES = 0;

Interested in SQL? Check out this SQL Certification by Intellipaat.

Related questions

Browse Categories

...