At 5:16 PM +0000 10/30/01, David Ayliffe wrote: >As subject what do I do if I want a field called (for example) >Competition ID? > >I have looked (http://www.mysql.com/doc/C/R/CREATE_TABLE.html) but to no >avail. >I have tried enclosing it in "quotes" and 'single quotes' but neither >work. Can this be done?
Check this section instead: http://www.mysql.com/doc/L/e/Legal_names.html You want to use back quotes (`Competition ID`). > >Thanks lots >David Ayliffe > >ICQ# 125646758 > >For the filter: MySQL, Table, Database --------------------------------------------------------------------- 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
