advanced code snippet search

Posted By

Abe on 01/11/08


Tagged

sql csv


Versions (?)

Who likes this?

3 people have marked this snippet as a favorite

vilebender
mh5777
jeremydouglass


Load CSV file to SQL DB

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. LOAD DATA LOCAL INFILE 'file.csv' INTO TABLE `locations` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\ r\ n'

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: Abe on January 24, 2008

You need to login to post a comment.