MySQL Forums
Forum List  »  MySQL for Excel

Deleting Rows
Posted by: Johnnie Birch
Date: December 05, 2013 11:09PM

Just starting got setup with MySQL workbench on windows to connect to a remote MySQL server. Connection is ok. Can create tables, add data, delete data. Then I found MySQL for Excel and see from http://www.mysql.com/why-mysql/windows/excel/edit/ that it says users can:

"Delete existing rows - users can delete existing rows the same way they would delete a row in MS Excel, the row is deleted from the worksheet and flagged for deletion."

But when I try to do this, the tool just things I modified a row and it complains about reusing primary keys.

Then I see in the FAQ: http://dev.mysql.com/doc/refman/5.6/en/mysql-for-excel-faq.html

"27.6.2: I click on Edit Data and after importing the table data into Excel, I can't sort or move columns around. How can I do that?

In order to maintain the mapping of rows and columns in the Excel Worksheet against the rows and columns in the MySQL table, no alteration is permitted on the worksheet (i.e. sorting, deleting rows, deleting columns). If you need to alter the data there you can do that by right-clicking the Edit Data window and selecting Exit Edit Mode."

So should I be able to delete a row or not with the MYSQL for Excel tool? I am using MySQL Installer 5.6.15.

Thanks,
Johnnie

Options: ReplyQuote


Subject
Views
Written By
Posted
Deleting Rows
3506
December 05, 2013 11:09PM
1048
December 10, 2013 06:14AM
1053
December 10, 2013 12:10PM


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.