Re: null columns after loading

2001-09-24 Thread Carl Troein
GUYOT Carole writes: > I'm trying to insert records from a file. These records are separated > with pipes. > > load data local infile "aid.exp" into table aid; How is MySQL supposed to know that you're using a non-standard way of separating your records if you don't tell it? :-O You need to sp

null columns after loading

2001-09-24 Thread GUYOT Carole
I'm trying to insert records from a file. These records are separated with pipes. use crous; load data local infile "aid.exp" into table aid; When I do "select * from aid" , the first column is OK but the second and third columns are nulls for all rows. It's weird! Has anyone experienced t