Avoid insert duplicate emails when importing from CSV file

[lopes_andre]

Hi, I need to insert to my email database new emails in CSV format, but I don't want to import duplicate emails.

 

 

Table Scheme:

 

id | email  (unique) | name

---------------------------

1 | expl1@mail.com | expl1

2 | expl2@mail.com | expl2

3 | expl3@mail.com | expl3

4 | expl4@mail.com | expl4

 

How can I import to this database new emails without insert duplicate emails?

 

The function LOAD DATA INFILE can do this, avoiding to insert duplicate emails in the UNIQUE field "email"?

 

Best Regards, André.

[php.ajax.coder]

You can use the email field as a primary key this prevents the same email being entered twice.

[lopes_andre]

Hi,

 

Thanks for your reply.

 

I don't explain me well. The email field is "unique", but I need to import data to this database and I know that some emails that I will import are duplicated, but because the field email is "unique" I think the import will stop with an error every time that one duplicate email is inserted(or tried to insert).

 

What I need to know is... there is some way do to this:

 

"if email allready in database, ignore that email and continue importing".

 

There is a way to do this, some mysql function?

 

Best Regards, André.

[fenway]

You can use INSERT IGNORE.