mysql - 来自多个和/或新 .CSV 文件的简单更新表

Question

编辑，因为它被认为太长

我有 1 个表，从 .CSV 导入的“customerdetails”，并希望使用具有相同结构的新 .CSV 文件“newcustomerrecords”对其进行更新

这是我使用的代码，但由于 1290 错误代码而失败

CREATE TEMPORARY TABLE temp_table LIKE customerdetails;

LOAD DATA INFILE 'C:/Documents/MySQL Test Databases/newcustomerdetails2020.csv'
INTO TABLE temp_table
FIELDS terminated by ','
(customer_ID, first_name, last_name, membership_id, email_address);

UPDATE customerdetails
INNER JOIN temp_table Customer_ID ON temp_table.customer_ID = customerdetails.customer_ID
SET customerdetails.Customer_ID = temp_table.Customer_ID;```

How do I

a: update customerrecords from newcustomerrecords
b: fix the 1290 error

Thanks

标签： mysqlcsv