No it is not. Reserved word list: http://www.mysql.com/doc/R/e/Reserved_words.html
I think Richard's problem is the NULL. You could do default NULL, but I think NULL by itself doesn't mean anything to mysql (in a create table, anyway). ----- Original Message ----- From: "rc" <[EMAIL PROTECTED]> To: "Richard W. Wood" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, October 31, 2001 9:06 AM Subject: Re: Problem adding table is data a reseverd word in mysql? On Wed, 31 Oct 2001, Richard W. Wood wrote: > I've been trying to add the following table to my database, and I keep > getting the error below. > > CREATE TABLE mod_userpage_data ( > id INT(5) NOT NULL default '0', > title VARCHAR(200) NULL, > data LONGTEXT NULL, > PRIMARY KEY (id) > ); > > ERROR 1064 at line 1: You have an error in your SQL syntax near 'data > LONGTEXT NULL, > PRIMARY KEY (id) > )' at line 4 > > Any help solving this would be appreciated. > RW Wood > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
