Try inserting like this:

INSERT IGNORE INTO tbl_name....


"Scott Immerman" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Say I have a Table (MySQL) with the field "PhoneNumber" that is UNIQUE.
>
> Now I want to import a file into the Table that may have some of the same
> phone numbers. Is there a way to do this, without the duplicate values
> stopping the import, and just skip them instead?
>
> Thanks,
> Scott
>
>
>
> _______ www.SEALsystems.Net ____________________________
>
> "Human history becomes more and more a race between
>         education and catastrophe."
>
>         - H.G. Wells
> ________________________________________________________
>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to