Re: Cannot create table with file named INFILE

2001-05-29 Thread Paul DuBois
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

Re: Cannot create table with file named INFILE

2001-05-28 Thread Alessandro Staltari
> 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

Re: Cannot create table with file named INFILE

2001-05-28 Thread B. van Ouwerkerk
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

Cannot create table with file named INFILE

2001-05-28 Thread Alessandro Staltari
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