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 use the
names of datatypes or functions built into MySQL, such as TIMESTAMP or GROUP. 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 names.
The following words are explicitly reserved in MySQL. Most of them are forbidden by
ANSI SQL92 as column and/or table names (for example, group). A few are reserved
because MySQL needs them and is (currently) using a yacc parser: " <snip following
list of reserved words>
Also, the MySQL documentation is very clear in what words are reserved words, and even
in which release they became so.
As far as I'm concerned, such clear documenting of the situation precludes this being
a secret, much less a dirty one...
Mark Chalkley
*********** REPLY SEPARATOR ***********
On 2/4/01 at 2:28 PM 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.
>
>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
>
>Why the mySQL developers never mention it is beyond
>me.
>
>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.
>
>
>
>
>__________________________________________________
>Get personalized email addresses from Yahoo! Mail - only $35
>a year! http://personal.mail.yahoo.com/
>
>---------------------------------------------------------------------
>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
******** END OF ORIGINAL TEXT *********
---------------------------------------------------------------------
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
