'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 |
|---|
