> Please check the manual before sending a question to this list.. says
every
> messages.. So:
>
> http://www.mysql.com/doc/R/e/Reserved_words.html
I read it (please note the (*)):
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.
(*) It is rather confusing. Is is alloweed or it is forbidden? Maybe it is
alloweed only for the functions but it is not so clear. In this case the
manual is not enough, I suppose.
> Workaround: give your table another name.
>
It's a joke? I'm porting my application from another database where that
INFILE field was alloweed, so it is not so easy. My hope was that maybe
there is in a kind of quoting or escape sequence that disables keyword
matching.
Regards
Alessandro Staltari.
---------------------------------------------------------------------
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
