MySQL update date where date is 0000-00-00
I imported some data from excel onto my database. Due to some formatting
errors, many of the ship dates are "0000-00-00". I want to change that to
NULL. I used the following query but it doesn't work. Can someone show me
the correct syntax?
UPDATE inventory SET shipdate = NULL WHERE shipdate IS '0000-00-00'
No comments:
Post a Comment