Re: Cant Explain Error Message

[Will K.]

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


---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php