From: Dan Nelson
Date: December 2 2002 2:08am
Subject: Re: Cant Explain Error Message
List-Archive: http://lists.mysql.com/mysql/126262
Message-Id: <20021202020848.GB25679@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Dec 02), Will K. said:
> Hello.
> 
> I am trying to create a table in one of my databases using textbook code, 
> but it is giving me an error message.  Here is how it reads:
> 
> mysql> create TABLE messages
>    -> (
>    -> id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
>    -> forum int not null,
>    -> author char(255) not null,
>    -> subject char(255) not null,
>    -> email char(255) not null,
>    -> date datetime not null,
>    -> ip char(255) not null,
>    -> message text not null,
>    -> thread_id not null
>    -> )
>    -> ;
> ERROR 1064: You have an error in your SQL syntax near 'not null
> )' at line 11
> 
> I have tried a few different ways of rewriting the id line, like this for 
> instance:
> 
> id int not null primary key auto_increment,

That's not line 11 though.  Line 11 is 

>    -> thread_id not null

, which is missing a column type.
 
-- 
	Dan Nelson
	dnelson@stripped