Import CSV to Update rows in table

by

You can use temporary table to hold the update data and then run single update statement.

CREATE TEMPORARY TABLE temp_update_table (meta_key, meta_value)

LOAD DATA INFILE 'your_csv_pathname' 
INTO TABLE temp_update_table FIELDS TERMINATED BY ';' (meta_key, meta_value); 

UPDATE "table"
INNER JOIN temp_update_table on temp_update_table.meta_key = "table".meta_key
SET "table".meta_value = temp_update_table.meta_value;

DROP TEMPORARY TABLE temp_update_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 to Import Multiple csv files into a MySQL Database
  5. Import CSV to Update only one column in table
  6. How I can Import data from CSV to MySQL?
  7. How to import a csv file into MySQL workbench?
  8. If two columns are 1 then make new column
  9. SQL split values to multiple rows
  10. How can I output MySQL query results in CSV format?
  11. MySQL: How to reset or change the MySQL root password?
  12. What is the opposite of GROUP_CONCAT in MySQL?
  13. MySQL Server has gone away when importing large sql file
  14. How to import data from text file to mysql database
  15. Why is the estimated rows count very different in phpmyadmin results?
  16. How to import XML file into MySQL database table using XML_LOAD(); function
  17. Migrate from Oracle to MySQL
  18. How to access remote server with local phpMyAdmin client?
  19. Dump all tables in CSV format using ‘mysqldump’
  20. How to skip columns in CSV file when importing into MySQL table using LOAD DATA INFILE?
  21. Regaining access to lost MySQL password for PHPMyAdmin on WAMP
  22. Bug? #1146 – Table ‘xxx.xxxxx’ doesn’t exist
  23. Creating functions in phpMyAdmin – Error: access denied you need the super privilege for this operation
  24. #1273 – Unknown collation: ‘utf8mb4_unicode_ci’ cPanel
  25. Dump a mysql database to a plaintext (CSV) backup from the command line
  26. Composite key as foreign key (sql)
  27. ERROR 1148: The used command is not allowed with this MySQL version
  28. how to delete duplicate rows from a table in mysql
  29. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  30. SQL: deleting tables with prefix

Leave a Comment