List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 4 2001 11:42pm
Subject:Re: About reserved words: mySQL's dirty little secret
View as plain text  
At 2:28 PM -0800 2/4/01, Heath Boutwell wrote:
>Evidently, one can use the ` to escape reserved words
>in mySQL.
>
>Why in the world this isn't mentioned in the manual is
>beyond me.

http://www.mysql.com/doc/L/e/Legal_names.html
http://www.mysql.com/doc/R/e/Reserved_words.html

>
>Why no one on the list ever mentions it when some poor
>sap discovers that some random word has been made
>reserved for no reason is beyond me

They're not exactly chosen at random, but yes, it's
unpleasant to find that a word you've used has become
reserved in a new release.

That's why it's a good idea to read the change notes
when a new release comes out. The developers try to
mention when a word becomes reserved due to the addition
of new features.

>
>Why the mySQL developers never mention it is beyond
>me.

See above.

>
>Anyway, since its undocumented, I'm guessing that it
>will magically quit working one day, but for now it
>seems to work like a charm.


-- 
Paul DuBois, paul@stripped
Thread
About reserved words: mySQL's dirty little secretHeath Boutwell4 Feb
  • Re: About reserved words: mySQL's dirty little secretRick Pasotto4 Feb
    • Re: About reserved words: mySQL's dirty little secretPaul DuBois5 Feb
  • Re: About reserved words: mySQL's dirty little secretMark Chalkley5 Feb
    • Re: About reserved words: mySQL's dirty little secretHeath Boutwell7 Feb
  • Re: About reserved words: mySQL's dirty little secretPaul DuBois5 Feb
  • Re: About reserved words: mySQL's dirty little secretfabio.ottolini5 Feb
    • Re: About reserved words: mySQL's dirty little secretPaul DuBois5 Feb
  • Re: About reserved words: mySQL's dirty little secretColin Faber5 Feb
    • Re: About reserved words: mySQL's dirty little secretPaul DuBois5 Feb
  • Re: About reserved words: mySQL's dirty little secretKen Menzel5 Feb
    • Re: About reserved words: mySQL's dirty little secretPaul DuBois5 Feb