Yes it is.. For a list of reserved words, see: http://www.mysql.com/doc/R/e/Reserved_words.html Gurhan
----- Original Message ----- From: "Peter Lovatt" <[EMAIL PROTECTED]> To: "Me" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, June 20, 2002 2:29 PM Subject: RE: Creation query problem!! > is read a reserved word? > > ----------------------------------------------- > Excellence in internet and open source software > ----------------------------------------------- > Sunmaia > www.sunmaia.net > [EMAIL PROTECTED] > tel. 0121-242-1473 > ----------------------------------------------- > > > -----Original Message----- > > From: Me [mailto:[EMAIL PROTECTED]] > > Sent: 20 June 2002 18:59 > > To: [EMAIL PROTECTED] > > Subject: Creation query problem!! > > > > > > Hello, will someone please point out what I am missing > > here for these creation query, one uses backquotes, > > while the other does not, for some reason, the one > > without back quotes errors!! What am i missing?? > > Is there a reserved word I am missing?? > > MySQL 3.23.41 > > > > CREATE TABLE email ( > > emailid int(11) NOT NULL auto_increment, > > oprid varchar(50) NOT NULL default '', > > folder varchar(50) NOT NULL default '', > > content text, > > custid varchar(20) NOT NULL default '', > > read varchar(5) NOT NULL default '', > > replied varchar(5) NOT NULL default '', > > row_insert_oprid varchar(50) NOT NULL default '', > > row_insert_dt datetime NOT NULL default '0000-00-00 > > 00:00:00', > > row_update_oprid varchar(50) NOT NULL default '', > > row_update_dt datetime NOT NULL default '0000-00-00 > > 00:00:00', > > PRIMARY KEY (emailid) > > ) TYPE=MyISAM; > > ERROR 1064: You have an error in your SQL syntax near > > 'read varchar(5) NOT NULL default '', > > replied varchar(5) NOT NULL default '',' at line 7 > > > > CREATE TABLE `email` ( > > `emailid` int(11) NOT NULL auto_increment, > > `oprid` varchar(50) NOT NULL default '', > > `folder` varchar(50) NOT NULL default '', > > `content` text, > > `custid` varchar(20) NOT NULL default '', > > `read` varchar(5) NOT NULL default '', > > `replied` varchar(5) NOT NULL default '', > > `row_insert_oprid` varchar(50) NOT NULL default '', > > `row_insert_dt` datetime NOT NULL default > > '0000-00-00 00:00:00', > > `row_update_oprid` varchar(50) NOT NULL default '', > > `row_update_dt` datetime NOT NULL default > > '0000-00-00 00:00:00', > > PRIMARY KEY (`emailid`) > > ) TYPE=MyISAM; > > > > ===== > > > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! - Official partner of 2002 FIFA World Cup > > http://fifaworldcup.yahoo.com > > > > --------------------------------------------------------------------- > > 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
