Import CSV to Update only one column in table

by

You can use LOAD DATA INFILE to bulk load the 800,000 rows of data into a temporary table, then use multiple-table UPDATE syntax to join your existing table to the temporary table and update the quantity values.

For example:

CREATE TEMPORARY TABLE your_temp_table LIKE your_table;

LOAD DATA INFILE '/tmp/your_file.csv'
INTO TABLE your_temp_table
FIELDS TERMINATED BY ','
(id, product, sku, department, quantity); 

UPDATE your_table
INNER JOIN your_temp_table on your_temp_table.id = your_table.id
SET your_table.quantity = your_temp_table.quantity;

DROP TEMPORARY TABLE your_temp_table;

More Related Contents:

  1. Import data in MySQL from a CSV file using LOAD DATA INFILE
  2. How to import a CSV file into a MySQL table
  3. How can I correct MySQL Load Error
  4. How I can Import data from CSV to MySQL?
  5. Import CSV to Update rows in table
  6. How to import a csv file into MySQL workbench?
  7. SQL split values to multiple rows
  8. How can I output MySQL query results in CSV format?
  9. How do I import CSV file into a MySQL table?
  10. What is the opposite of GROUP_CONCAT in MySQL?
  11. MySQL load NULL values from CSV data
  12. Importing CSV data using PHP/MySQL
  13. How to import data from text file to mysql database
  14. MySQL: Split comma separated list into multiple rows
  15. How to import XML file into MySQL database table using XML_LOAD(); function
  16. Migrate from Oracle to MySQL
  17. Mysql string split [duplicate]
  18. Dump all tables in CSV format using ‘mysqldump’
  19. How to skip columns in CSV file when importing into MySQL table using LOAD DATA INFILE?
  20. LOAD DATA LOCAL INFILE gives the error The used command is not allowed with this MySQL version
  21. Importing a CSV to MySQL with different date format
  22. mysql pivot query results with GROUP BY
  23. Import SQL file into mysql
  24. How to export data from SQL Server 2005 to MySQL [closed]
  25. Dump a mysql database to a plaintext (CSV) backup from the command line
  26. How to Import Multiple csv files into a MySQL Database
  27. How can I import a database with MySQL from terminal?
  28. ERROR 1148: The used command is not allowed with this MySQL version
  29. How to insert selected columns from a CSV file to a MySQL database using LOAD DATA INFILE
  30. How to join two tables using a comma-separated-list in the join field

Leave a Comment