Perhaps you read the wrong part(s) of the manual: http://www.mysql.com/doc/R/e/Reserved_words.html
On Sun, 20 Jan 2002 12:18:45 -0800 (PST), Dominique Plante wrote: >I hope you can answer the following question. I am >wondering how to create a table with a column named >key. I have RTFMed and that didn't help. I'm using >3.23.47-max-debug. > > >The following fails (after selecting a database): > >mysql> create table test (key varchar(255), value >varchar(255)); > >With the following error: >ERROR 1064: You have an error in your SQL syntax near >'varchar(255), value varch >ar(255))' at line 1 > >Any suggestions? > >Many thanks, >Dominique > >__________________________________________________ >Do You Yahoo!? >Send FREE video emails in Yahoo! Mail! >http://promo.yahoo.com/videomail/ > >--------------------------------------------------------------------- >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