LOAD DATA LOCAL INFILE '/home/me/yo.csv' INTO TABLE 1by1_email FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY "\n" IGNORE 1 LINES (fields,fields...);
Tuesday, June 2, 2009
Import a csv file (with header line) into mysql with LOAD DATA
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment