It's always a bad idea to name your columns using keywords. ----- Original Message ----- From: "olinux" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 14, 2002 5:42 AM Subject: Why must I quote fields now?
> Hi all, > > I have just added a field (order) to a table with > about 12,000 records. > > Now I cannot select or insert unless I quote the field > names in the query > > i.e. This returns - you have an error near 'order ...' > SELECT > id,pub_date,last_update,type,region,author,title,summary,content,keywords,fi lename,order > FROM articles WHERE id = 23692 > > but this works fine. > SELECT > `id`,`pub_date`,`last_update`,`type`,`region`,`author`,`title`,`summary`,`co ntent`,`keywords`,`filename`,`order` > FROM `articles` WHERE `id` = 23692 > > I have no idea why, has the table been corrupted? > > I'm running MySQL 3.23.48 > > Thanks, > olinux > > __________________________________________________ > Do you Yahoo!? > Faith Hill - Exclusive Performances, Videos & More > http://faith.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