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
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