Load .csv into MySQL

LOAD DATA INFILE 'data.txt' INTO TABLE test.lgmweb
  FIELDS TERMINATED BY ',' ENCLOSED BY '"'
  LINES TERMINATED BY '\r\n'
  IGNORE 1 LINES;