'MySQL importing and replace [duplicate]

I have a table with 2 columns:

Id | Date
1  | 2022-04-01

With tons of row, like 30k

I need modify all the dates, so I want to upload a CSV with same columns but different dates.

1 | 2023-04-03

But I need that the date be replaced (not add new rows).

So put the dates that I am upload in the row that have same id

Example, uploading that will change:

1 | 2022-04-01 

For

1 | 2023-04-03

And everything in bulk, because the table has more than 30,000 rows

How can I do it this in Mysql? With a CSV file to upload

Thanks in advance!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source