MySQL Forums
Forum List  »  MySQL for Excel

Re: Failure to update database
Posted by: adam mcgrath
Date: March 14, 2014 11:12AM

Similar problem here.

I have a table with address, features, price, etc.

I'm trying and update the price, some rows work without a hitch, and confirmed on the site.

Some rows return the error: : "Query did not match any rows in the DB, values in the row may have changed; please refresh values from the DB."

I am committing the changes one cell at a time.

Excel 2013 O365 Small business. Windows 8, just installed excel for mysql today.

As recommended in this thread I tired without optimistic updates, still receive the error on the same cells.

*Edit* I have one column that is majority empty, called NAME. When i remove
AND `name`=''
from the previewed command it updated correctly and pushed to the site.

Edited 1 time(s). Last edit at 03/14/2014 11:18AM by adam mcgrath.

Options: ReplyQuote

Written By
February 27, 2014 11:42AM
February 27, 2014 01:21PM
March 03, 2014 04:13PM
March 03, 2014 04:10PM
March 03, 2014 05:13PM
March 04, 2014 04:41PM
March 04, 2014 05:15PM
March 05, 2014 12:41PM
Re: Failure to update database
March 14, 2014 11:12AM
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.