How to insert selected columns from a CSV file to a MySQL database using LOAD DATA INFILE

by

Load data into a table in MySQL and specify columns:

LOAD DATA LOCAL INFILE 'file.csv' INTO TABLE t1 
FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'  
(@col1,@col2,@col3,@col4) set name=@col4,id=@col2 ;

@col1,2,3,4 are variables to hold the csv file columns (assume 4 ) name,id are table columns.

More Related Contents:

  1. SQL split values to multiple rows
  2. How can I output MySQL query results in CSV format?
  3. How do I import CSV file into a MySQL table?
  4. Import data in MySQL from a CSV file using LOAD DATA INFILE
  5. What is the opposite of GROUP_CONCAT in MySQL?
  6. MySQL load NULL values from CSV data
  7. How to import a CSV file into a MySQL table
  8. MySQL: Split comma separated list into multiple rows
  9. Importing a csv into mysql via command line
  10. Mysql string split [duplicate]
  11. Dump all tables in CSV format using ‘mysqldump’
  12. How to skip columns in CSV file when importing into MySQL table using LOAD DATA INFILE?
  13. Import CSV to MySQL
  14. LOAD DATA LOCAL INFILE gives the error The used command is not allowed with this MySQL version
  15. Importing a CSV to MySQL with different date format
  16. mysql pivot query results with GROUP BY
  17. How to export data from SQL Server 2005 to MySQL [closed]
  18. Dump a mysql database to a plaintext (CSV) backup from the command line
  19. How can I correct MySQL Load Error
  20. How to join two tables using a comma-separated-list in the join field
  21. Import CSV to Update only one column in table
  22. How I can Import data from CSV to MySQL?
  23. Import CSV to Update rows in table
  24. How to import a csv file into MySQL workbench?
  25. ROW_NUMBER() in MySQL
  26. MYSQL Select MAX Date inside a join statement
  27. TRIGGERs that cause INSERTs to fail? Possible?
  28. Mysql query to dynamically convert rows to columns on the basis of two columns
  29. MySQL my.ini location
  30. How to search for rows containing a substring?

Leave a Comment