in reply to Re: Problem uploading 'large' CSV file using DBI
in thread Problem uploading 'large' CSV file using DBI
I'm beginning to think it might be best for me to wrap all the fields in "" instead of just the strings and add ; as an ending just to insure nothing is being missed.%mysql > load data local infile '/home/champ1/public_html/admin/dump/t +eachers1999.csv' into table salary_teacher_1999 fields terminated by +"," optionally enclosed by """" lines termintated by "\r" ; %
|
|---|