RE: [PHP-DB] MySQL Returns Error
| From: | Matt Schroebel | Date: | Tue, 05 Aug 2003 18:06:10 +0000 |
| Subject: | RE: [PHP-DB] MySQL Returns Error | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-29690@lists.php.net to get a copy of this message | ||
Change the gradient definition to:
gradient MEDIUMINT(10) NOT NULL AUTO_INCREMENT,
> -----Original Message-----
> From: Jeff [mailto:jroth1@telus.net]
> Sent: Tuesday, August 05, 2003 1:44 PM
> To: php-db@lists.php.net
> Subject: Re: [PHP-DB] MySQL Returns Error
>
>
> Ok, that worked,
>
> Now the error I'm getting is "Duplicate entry ' ' for key 1"
>
> Is this a SQL table error?
>
> Here's my Table as entered:
>
> CREATE TABLE gradients (
> gradient MEDIUMINT(10) DEFAULT '0' NOT NULL AUTO_INCREMENT,
> .........
> tag VARCHAR(15) NOT NULL,
> PRIMARY KEY (lsd),
> UNIQUE gradient (gradient)
> );