# Importing CSV data to Exsiting MySQL Table?

**URL:** https://forum.kirupa.com/t/importing-csv-data-to-exsiting-mysql-table/229744
**Category:** programming
**Created:** [June 19, 2007, 9:06pm UTC](https://forum.kirupa.com/t/importing-csv-data-to-exsiting-mysql-table/229744 "2007-06-19T21:06:54Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![duncanhall](https://avatars.discourse-cdn.com/v4/letter/d/ad7895/32.png) [@duncanhall](https://forum.kirupa.com/u/duncanhall)
#### Post date: [June 19, 2007, 9:06pm UTC](https://forum.kirupa.com/t/importing-csv-data-to-exsiting-mysql-table/229744/1 "2007-06-19T21:06:54Z")

</div>

I have a spreadsheet of details for 100 students.

It has columns for:

student\_id, telephone\_number, email\_address, website

I also have a MySQL table of student details, with blank fields for telephone number, email, and web address. It already contains data in various other fields that I don’t want to touch. The student\_id’s in the spreadsheet match those of the MySQL table.

What is the best/quickest way to import the spreadsheet data, matching up the student\_ids ?