No errors, nothing, just loads that first line like above.
%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" ;
%
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.
"Recognizing who we aren't is only the first step toward knowing who we are." - Os Guinness
|