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? I believe `Competition ID` (back-quotes) should work. But this can be painful for the next person to read. What's so bad about CompetitionID (no spaces) or Competition_ID (underscore)? Both make it more readable, and you don't have to resort to ugly SQL syntax.. -- Shankar. --------------------------------------------------------------------- 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
