MySQL Forums
Forum List  »  MySQL for Excel

Re: Failure to update database
Posted by: Javier Treviño
Date: March 03, 2014 04:10PM

Hi Tom,
Thanks for writing in our forums.
I have questions based on the information you provided:

1. Is your intention to delete the row or just clear some of the values? Clearing the values of a row is not the same as deleting it.
2. Are you connecting to a DB where multiple users may be updating the data?
3. How do the queries generated by the Edit Data operation look like? If you do not see any SQL query you need to access the Global Options dialog (there is a button on the panel where you clicked Edit Data where you display those options) and select either the radio button to preview SQL queries before they are sent to the DB or the one that shows the executed SQL queries along with their results.

Please provide the information in a further reply to see what is happening.
In case the answer to my first question is that you want to delete the whole row, then delete the Excel row by right-clicking on it just the way you would delete the row in Excel.

Best Regards.

Javier Treviño
MySQL on Windows Team

Options: ReplyQuote

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