MySQL Forums
Forum List  »  Newbie

0 rows effected with UPDATE Query
Posted by: Jay Mackey
Date: February 14, 2018 11:11PM

UPDATE SensorConfig SET Date = 2018-12-15
WHERE Date = 2018-02-05;

Query OK, 0 rows affected, 1 warning, rows matched: 0 Changed: 0 Warnings: 1

Why doesn't this update all the date rows in my SensorConfig table?

The datatype for the Date field = Date.

Options: ReplyQuote


Subject
Written By
Posted
0 rows effected with UPDATE Query
February 14, 2018 11:11PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.