MySQL Forums
Forum List  »  Newbie

Re: Loading table from CSV - Help required
Posted by: Guelphdad Lake
Date: February 02, 2009 09:10PM

yes it is possible. what would you like to do with the rows that violate the primary key?

an example.

you could change the primary key so it isn't a primary key while you import the rows and assign an auto_increment column afterwards to ensure unique rows.

you could then return any rows where the emp_no is duplicated.

Options: ReplyQuote


Subject
Written By
Posted
Re: Loading table from CSV - Help required
February 02, 2009 09: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.