I would say line 2, DEFAULT 0 not DEFAULT '0'.
- Original Message -
From: "Syed sumair" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Friday, June 01, 2001 7:11
Subject: What is the error in this sql query
> What is the error in this sql query ???
>
I believe the ENUM-length is faulty!
It should be somthing like this:
have_vote ENUM("yes", "no"),
Check the manual:
http://www.mysql.com/doc/E/N/ENUM.html
\d
-Original Message-
From: Syed sumair [mailto:[EMAIL PROTECTED]]
Sent: den 1 juni 2001 01:11
To: MySQL Lis
have_vote ENUM (3),
must be this:
have_vote ENUM ('3'),
Greetings,
Ansgar
> What is the error in this sql query ???
> _
> CREATE TABLE page(
> page_ID INT (9) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT,
> relative_path VARCHAR (200) Not NULL,
> key
