在DB和文档中的列的特定ID之后相应地导入数据[重复]

This question already has an answer here:

Import Column from CSV into existing MySQL Table 1 answer
Import CSV to Update only one column in table 2 answers

I got an existing table with bunch of columns and values:

+ID    fruit column2 column3
|1     Apple   value   value
|2     Banana   value   value
|3     Orange   value   value
|4     Pear   value   value

Now I want to import another column to this table. The document with the new column I want to import already has all the existing IDs the database got. I then want to order them accordingly next to their own ID number.

I do not want to update a column, I want to add a new column and place the new values in a row where the IDs match in the document and in the database.

3     Orange
2     Yellow
1     Red
4     Pear

The new updated table would then look like this:

+ID    color    fruit column2 column3
|1     Red      Apple   value   value
|2     Yellow   Banana   value   value
|3     Orange   Orange   value   value
|4     Green    Pear   value   value

Then my question is as following: How could this be done? Can tools like phpMyAdmin do this for you automatically? What would you suggest to be the easiest way?

I want to add that this is a document and a database with well-over 8000 rows. And possible solutions are much appreciated.

</div>