I keep trying to load about a 1000 records into a mysql table
load into file 'path/text.txt' into tablname
fields terminated by ','
enclosed by '"'
lines terminated by '\n\n';
the records are pretty long i think i have about 35 fields
it says it loads fine but only loads one of the records and not all of them.
the ercords look something like:
"Mr.","mo ","T. ","Crimmins ","","Oil Company","4304 Plaza","P.O. Box ","Houston, ","TX ","77252","","fax number","(800) phone number","","I","14","Industry","Southwest (Houston)","","","","Yes","y","12/14/1998","","","","","","18975","$90.00","","","2"
"Mr.","Chuck","M.","Bob",""," Bruce, LLP","1072 Street, NW","","Washington,","DC","zip","","fax number","phone number","email","L","3 ","Law Firm","District of Columbia","","","","Yes","y","6/16/1999","","","","","","5161","$0.00","","","2"
i have looked through the mysql documentation but cant find what i am doing wrong
any help is appreciated
jake
load into file 'path/text.txt' into tablname
fields terminated by ','
enclosed by '"'
lines terminated by '\n\n';
the records are pretty long i think i have about 35 fields
it says it loads fine but only loads one of the records and not all of them.
the ercords look something like:
"Mr.","mo ","T. ","Crimmins ","","Oil Company","4304 Plaza","P.O. Box ","Houston, ","TX ","77252","","fax number","(800) phone number","","I","14","Industry","Southwest (Houston)","","","","Yes","y","12/14/1998","","","","","","18975","$90.00","","","2"
"Mr.","Chuck","M.","Bob",""," Bruce, LLP","1072 Street, NW","","Washington,","DC","zip","","fax number","phone number","email","L","3 ","Law Firm","District of Columbia","","","","Yes","y","6/16/1999","","","","","","5161","$0.00","","","2"
i have looked through the mysql documentation but cant find what i am doing wrong
any help is appreciated
jake