mysql import data from large csv file

Solutions on MaxInterview for mysql import data from large csv file by the best coders in the world

we are a community of more than 2 million smartest coders
registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now
  
pinned-register now
showing results for - "mysql import data from large csv file"
Marie
28 Aug 2018
1LOAD DATA INFILE 'data.csv' INTO TABLE tbl_name 
2FIELDS TERMINATED BY ',' 
3ENCLOSED BY '"' 
4LINES TERMINATED BY '\r\n' 
5IGNORE 1 LINES;