Re: Load Data Infile confusion

2003-11-18 Thread Kim G. Pedersen
Hello Robert ,, I have no explanation , just a dummy question , 1) Are all values u try to put into column 5 a float with . ? 2) what if u try with integer ?? without . ? 3) can u input float values in column 3 ? 4) are u running mysqlcc from same pc ? 5 could it be some settings with decimal

Re: Load Data Infile confusion

2003-11-18 Thread Robert Bateman
Thanks for the reply Kim! On Tuesday 18 November 2003 12:47 pm, you wrote: Hello Robert ,, I have no explanation , just a dummy question , 1) Are all values u try to put into column 5 a float with . ? Always floats. 2) what if u try with integer ?? without . ? haven't yet tried. 3)

Load Data Infile confusion

2003-11-17 Thread Robert Bateman
This one has had me scratching my head all afternoon. I have a comma delimited text file that I am using to import data from a legacy system into a MyISAM table. My server is 4.0.16 as is my client. Both run on Redhat 8.0. An example line of imput looks like