Re: Cannot create table with file named INFILE

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

Cannot create table with file named INFILE

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

Re: Cannot create table with file named INFILE

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

Re: Cannot create table with file named INFILE

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