List:General Discussion« Previous MessageNext Message »
From:Ayyapraju Ganapathiraju Date:February 18 2003 6:51pm
Subject:Re: reserved or key words as database object names.
View as plain text  
Excellent, Thanks a lot. It worked.

----- Original Message -----
From: "Dan Nelson" <dnelson@stripped>
To: "Ayyapraju Ganapathiraju" <aganapa@stripped>
Cc: <mysql@stripped>
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
> dnelson@stripped
> 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 <mysql-thread132730@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-aganapa=hotmail.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
Thread
reserved or key words as database object names.Ayyapraju Ganapathiraju18 Feb
  • Re: reserved or key words as database object names.Dan Nelson18 Feb
  • Re: reserved or key words as database object names.Ayyapraju Ganapathiraju18 Feb