Load CSV file to SQL DB


/ Published in: SQL
Save to your folder(s)



Copy this code and paste it in your HTML
  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

You need to login to post a comment.