Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Re^2: Problem uploading 'large' CSV file using DBI

by Tatnall (Beadle)
on Jul 27, 2005 at 14:47 UTC ( [id://478619]=note: print w/replies, xml ) Need Help??


in reply to Re: Problem uploading 'large' CSV file using DBI
in thread Problem uploading 'large' CSV file using DBI

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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://478619]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others chanting in the Monastery: (3)
As of 2024-04-25 23:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found