ALTER TABLE $table ADD $value2 TEXT NUT NULL

Hey i'm getting this error: You have an error in your SQL syntax near 'NUT NULL' at line 1 when i run this query, ALTER TABLE $table ADD $value2 TEXT NUT NULL from the documentation i understood that this was the correct notation. any ideas? thanks Jule

Re: ALTER TABLE $table ADD $value2 TEXT NUT NULL

Hello, Try using NOT NULL. As weird as MySQL can be, don't think it is that NUTty. =) Harrison - Original Message - From: Jule [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 17, 2002 7:00 PM Subject: ALTER TABLE $table ADD $value2 TEXT NUT NULL Hey i'm getting this error

Re: ALTER TABLE $table ADD $value2 TEXT NUT NULL

Hello, Try using NOT NULL. As weird as MySQL can be, don't think it is that NUTty. =) Harrison - Original Message - From: Jule [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 17, 2002 7:00 PM Subject: ALTER TABLE $table ADD $value2 TEXT NUT NULL Hey i'm getting this error