Advanced Search

Insert into mysql from csv file

/ Published in: MySQL
Save to your folder(s)
ensure the url to the csv file is in the root of your file system (eg: C:/mycsvfile.csv)

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. LOAD DATA LOCAL INFILE '/file.csv' INTO TABLE `table_name` FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'
  2. (field1,field2,etc)

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.