RE: [PHP] sql blues
| From: | indrek siitan | Date: | Sat, 02 Dec 2000 19:37:36 +0000 |
| Subject: | RE: [PHP] sql blues | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-28384@lists.php.net to get a copy of this message | ||
Hi,
> Please can someone tell me what I'm doing wrong in the sql (mysql)
> below:
> $sql = "CREATE TABLE emailreg2 (
> dateandtime timestamp(14),
> email varchar(80) NOT NULL,
> name varchar(80) NOT NULL,
> openclosed varchar(10) NOT NULL DEFAULT 'open'
> urn int(9) unsigned zerofill NOT NULL DEFAULT 000000000
> AUTO_INCREMENT,
> UNIQUE IDX_urn (urn)
> )";
AUTO_INCREMENT field must be defined as a primary key.
Rgds,
Tfr
--==< tfr@mysql.com >==< MySQL development team >==< Tallinn / Estonia >==--