Re: Importing values into a unique field
| From: | Denis Arh | Date: | Thu, 25 Jul 2002 11:00:16 +0000 |
| Subject: | Re: Importing values into a unique field | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20778@lists.php.net to get a copy of this message | ||
Try inserting like this:
INSERT IGNORE INTO tbl_name....
"Scott Immerman" <php@SEALsystems.Net> wrote in message
news:B96513F2.16255%php@SEALsystems.Net...
> 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
> ________________________________________________________
>
>