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