Excellent, Thanks a lot. It worked. ----- Original Message ----- From: "Dan Nelson" <[EMAIL PROTECTED]> To: "Ayyapraju Ganapathiraju" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, February 18, 2003 1:37 PM Subject: Re: reserved or key words as database object names.
> In the last episode (Feb 18), Ayyapraju Ganapathiraju said: > > I need to create a table named "Case", but MySQL is rejecting it, may > > be because it is a reserved word. I understand that I can change the > > name to something sensible. Is there still a way to create a table > > with such names, for example, by enclosing them in double quotes. I > > would like to use such names for compatibility reasons with other > > database we are currently using. > > You can quote reserved words by enclosing them in backtics: `Case` > > -- > Dan Nelson > [EMAIL PROTECTED] > sql query > > --------------------------------------------------------------------- > 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