MySQL Forums
Forum List  »  MySQL for Excel

On append, skip rows which are filtered out in Excel?
Posted by: Ries Spruit
Date: January 14, 2015 02:34AM

I just appended a number of rows to a table using the MySQL for Excel plugin.

I used a defined table in Excel as the input. I had filtered the table to show only the rows that should be appended.

I was surprised to learn that upon completion, the rows which were visually filtered out had actually also been inserted, without any notification (expect the higher number of rows mentioned in the logging ).

Any help on how to work with filtered rows like this, is appreciated.

Options: ReplyQuote


Subject
Views
Written By
Posted
On append, skip rows which are filtered out in Excel?
2095
January 14, 2015 02:34AM


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.