RE: [PHP] sql blues
| From: | Mark Maggelet | Date: | Sat, 02 Dec 2000 23:01:49 +0000 |
| Subject: | RE: [PHP] sql blues | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-28396@lists.php.net to get a copy of this message | ||
On Sat, 2 Dec 2000 21:37:36 +0200, indrek siitan (tfr@mysql.com)
wrote:
>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.
no, it's the missing comma after 'open'.
- Mark