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