CODEWITHSUNDEEP
mysql
tsipi
tsipi

Reputation: 3

How to update a field a null value?

Tried to use these two commands but both didn't work:

update planes set year = 2013 where year is null;

and 

update planes set year = 2013 where year = null;

planes - table name

Upvotes: 0

Views: 72

Answers (1)

Krishnakumar
Krishnakumar

Reputation: 745

You can unset the safe mode 

SET SQL_SAFE_UPDATES = 0;

and then run your Query

Upvotes: 1

Related Questions