List:General Discussion« Previous MessageNext Message »
From:Will K. Date:December 2 2002 2:26am
Subject:Re: Cant Explain Error Message
View as plain text  
Thanks...  syslexia ducks...

Wil

-------------------------------
>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.


_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail

Thread
Cant Explain Error MessageWill K.2 Dec
  • Re: Cant Explain Error MessageDan Nelson2 Dec
Re: Cant Explain Error MessageWill K.2 Dec