I got caught this morning, now it's your turn. "read" is a reserved word in MySQL
-----Original Message----- From: Me [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 12:59 PM 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
