how do i convert a data base in csv formate to mysql?

Question

i have a data base in csv formate , i will like to know how to use it in php mysql . i am building a website for a school and they have the grades in csv format and the site i am building is in php mysql . i will like to know how to convert the csv format to a formate that can be used in mysql

Answer 1

CSV is a file format, and MySQL is a data server. In order to migrate the data from CSV to MySQL you must execute a series of insert statements that will insert all of the data into the correct tables.

Download the MySQL Administrator and the MySQL Migration Toolkit (http://mysql.com/products/tools/administrator/ and http://mysql.com/products/tools/migration-toolkit/ ) to import the CSV data into a MySQL database.

Answer 2

Write a php script which will read data from csv file and insert it to the mysql database. If the csv file is too huge, then run php from command prompt to insert the data.

Answer 3

You can read in the file and insert the entries into mysql programatically. Or, depending on what mysql software you might have, you can use it to import.