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.
Subject
Written By
Posted
0 rows effected with UPDATE Query
February 14, 2018 11:11PM
February 15, 2018 12:14AM
February 15, 2018 10:44PM
February 16, 2018 12:05AM
February 17, 2018 10:29AM
February 17, 2018 11:26AM
February 19, 2018 11:09AM
February 19, 2018 01:43PM
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.