MySQL Forums
Forum List  »  Newbie

Re: Hide rows in table1 based on same content in table2
Posted by: Peter Brawley
Date: November 07, 2021 11:39AM

I've no clue what DB4S is, but if you're using MySQL, here's a simple solution for your problem: create a primary or unique key on the columns that you don't want duplicated, and include the keyword IGNORE in your Load Data command, see https://dev.mysql.com/doc/refman/8.0/en/load-data.html.

Options: ReplyQuote


Subject
Written By
Posted
Re: Hide rows in table1 based on same content in table2
November 07, 2021 11:39AM


Sorry, only registered users may post in this forum.

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.