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 VARCHAR (200) , have_vote ENUM (3), PRIMARY KEY(page_ID), UNIQUE(page_ID),

Re: What is the error in this sql query

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, keywords

RE: What is the error in this sql query

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 VARCHAR (200) , have_vote ENUM (3), PRIMARY

Re: What is the error in this sql query

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