how to import csv file and check duplicates

[pixeltrace]

hi,

 

is there any sql code that can import csv file into your mysql db and at the same

time checked or send a report of the duplicate items?

currently this is the query that i use for uploading csv file

	LOAD DATA INFILE 'jos_muse_users1.csv' 
INTO TABLE jos_muse_users 
FIELDS 
    TERMINATED BY ',' 
    OPTIONALLY ENCLOSED BY '"' 
    ESCAPED BY '\\' 
LINES TERMINATED BY '\n'
(MemberID, ContactID, GivenName, FamilyName, Email, AddressedAsEmail, HomePhone, BusinessPhone, Mobile, Gender, DateofBirth, Address1, Address2, PostalCode, SourceFrom, NRIC, Race, Nationality, ChildName, ChildDOB, ChildGender, City, State, Country, SourcePortal)

 

hope you could help me with this.

 

thanks!