Re: MySQL Error???
| From: | CC Zona | Date: | Thu, 28 Jun 2001 06:01:05 +0000 |
| Subject: | Re: MySQL Error??? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-9880@lists.php.net to get a copy of this message | ||
In article <C3C8C2499A63D211BB7D00A0C9E1C706941216@PRI-NT1>,
bgrayless@Premier-Resorts.com (Brian Grayless) wrote:
> Is anyone familiar with this MySQL error?
>
> "1062: Duplicate entry '127' for key 1"
You have a unique key (likely the primary key field). There is already a
record with value "127" in that field.
> I wrote a great bookmark management program that works fine, but everytime I
> insert bookmarks, I insert somewhere over 120 and I start getting this
> error, and it won't add them anymore. Any suggestions???
For options, see the MySQL docs on the "insert ignore" and "replace"
keywords.
--
CC