MySQL Forums
Forum List  »  MySQL for Excel

Re: Failure to update database
Posted by: Tom Rust
Date: March 04, 2014 05:15PM

Ok. I inserted a data into column 2, (which it did do).
Then I tried to delete the row. Here is the code it generated:
DELETE FROM `subhash`.`monitormate3_flexnet` WHERE `date`='2014-03-04 00:00:00' AND `address`=null;

And here is the message it gave:
The server returned 1 warning(s):
The following SQL statements produced warnings:
1: DELETE FROM `subhash`.`monitormate3_flexnet` WHERE `date`='2014-03-04 00:00:00' AND `address`=null
1: Query did not match any rows in the DB, values in the row may have changed; please refresh values from the DB.

Options: ReplyQuote


Subject
Views
Written By
Posted
4342
February 27, 2014 11:42AM
1796
February 27, 2014 01:21PM
1671
March 03, 2014 04:13PM
1799
March 03, 2014 04:10PM
1441
March 03, 2014 05:13PM
1526
March 04, 2014 04:41PM
Re: Failure to update database
1921
March 04, 2014 05:15PM
1548
March 05, 2014 12:41PM
1657
March 14, 2014 11:12AM
1510
March 14, 2014 07:41PM


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.