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 que
2001 01:11
To: MySQL List
Subject: What is the error in this sql query
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,
keywords VAR
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,
> r
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,
keywords VARCHAR (200) ,
have_vote ENUM (3),
PRIMARY KEY(page_ID),
UNIQUE(page_
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,
keywords VARCHAR (200) ,
have_vote ENUM (3),
PRIMARY KEY(page_ID),
UNIQUE(page_
