Re: About reserved words: mySQL's dirty little secret

2001-02-07 Thread Heath Boutwell
I guess my command of the english language isn't too great. I never realized that this quote from the manual: "You're allowed to do it (for example, ABS is an allowed column name), but whitespace is not allowed between a function name and the `(' when using functions whose names are also column

Re: About reserved words: mySQL's dirty little secret

2001-02-05 Thread Paul DuBois
D]>; <[EMAIL PROTECTED]> >Sent: Sunday, February 04, 2001 6:49 PM >Subject: Re: About reserved words: mySQL's dirty little secret > > >> At 5:45 PM -0500 2/4/01, Rick Pasotto wrote: >> >If reserved words are such a big deal why are they not even >mention

Re: About reserved words: mySQL's dirty little secret

2001-02-05 Thread Paul DuBois
At 7:39 PM -0700 2/4/01, Colin Faber wrote: >Paul I expect to see documentation append to the copy of your book I bought 8 >months ago ;-) Do you prefer tape or staples? >Paul DuBois wrote: > >> On Sun, Feb 04, 2001 at 11:32:42PM -0200, Fábio Ottolini wrote: >> > Paul, >> > >> > Tomorrow th

Re: About reserved words: mySQL's dirty little secret

2001-02-05 Thread Ken Menzel
Rick Pasotto" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, February 04, 2001 6:49 PM Subject: Re: About reserved words: mySQL's dirty little secret > At 5:45 PM -0500 2/4/01, Rick Pasotto wrote: > >If reserved words are such a big deal why are they not ev

Re: About reserved words: mySQL's dirty little secret

2001-02-04 Thread Colin Faber
Paul I expect to see documentation append to the copy of your book I bought 8 months ago ;-) Paul DuBois wrote: > On Sun, Feb 04, 2001 at 11:32:42PM -0200, Fábio Ottolini wrote: > > Paul, > > > > Tomorrow they are going to add a new feature named "over the air select". > > Why this is not on you

Re: About reserved words: mySQL's dirty little secret

2001-02-04 Thread Paul DuBois
e - > From: "Paul DuBois" <[EMAIL PROTECTED]> > To: "Rick Pasotto" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Sunday, February 04, 2001 9:49 PM > Subject: Re: About reserved words: mySQL's dirty little secret > > > > At 5:

Re: About reserved words: mySQL's dirty little secret

2001-02-04 Thread Fábio Ottolini
L PROTECTED]> Sent: Sunday, February 04, 2001 9:49 PM Subject: Re: About reserved words: mySQL's dirty little secret > At 5:45 PM -0500 2/4/01, Rick Pasotto wrote: > >If reserved words are such a big deal why are they not even mentioned > >in the DuBois book? Or if they are

Re: About reserved words: mySQL's dirty little secret

2001-02-04 Thread Paul DuBois
At 5:45 PM -0500 2/4/01, Rick Pasotto wrote: >If reserved words are such a big deal why are they not even mentioned >in the DuBois book? Or if they are I haven't come across it. Certainly >'reserved' does not appear in the index. Guilty as charged. With reference to the use of `` to quote reserv

Re: About reserved words: mySQL's dirty little secret

2001-02-04 Thread Paul DuBois
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 t

Re: About reserved words: mySQL's dirty little secret

2001-02-04 Thread Mark Chalkley
As for documentation, does this count? http://www.mysql.com/doc/R/e/Reserved_words.html Or, to quote from section 7.39 of the manual, which the above link will take you to: "7.39 Is MySQL Picky About Reserved Words? A common problem stems from trying to create a table with column names that us

Re: About reserved words: mySQL's dirty little secret

2001-02-04 Thread Rick Pasotto
If reserved words are such a big deal why are they not even mentioned in the DuBois book? Or if they are I haven't come across it. Certainly 'reserved' does not appear in the index. -- "Democracy extends the sphere of individual freedom; socialism restricts it. Democracy attaches all possible v