At 2:23 PM +0200 5/28/01, Alessandro Staltari wrote:
>Hello. I'm new to MySQL but I have a problem that appears serious,
>al least for me.
>I can't create a table with a field named INFILE. I think mysql
>consider INFILE as a keyword. Is there work around for this?
>Shouldn't INFILE be used only
> 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
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
Workaround: give your table another name.
Bye,
B.
At 14:23 28-5-01 +0200, Alessandro Staltari wrote:
>Hello. I'm new to MySQL but I have a problem tha
Hello. I'm new to MySQL but I have a problem that appears serious, al least for me.
I can't create a table with a field named INFILE. I think mysql consider INFILE as a
keyword. Is there work around for this?
Shouldn't INFILE be used only within a LOAD statement? I think it is a bug in the
query