Re: upload csv information into related tables

[Lachlan Mulcahy]

Hi Roginald,

MySQL's CSV loading is quite straightforward in functionality.

If you have one flat CSV file for all of your tables, you will need to write some kind of importing utillity yourself. If you can export each table to a seperate CSV file and the tables contain fields that logically link the tables by the data itself, then it is simply a matter of using the 'mysqlimport' script or LOAD DATA INFILE command for each of those CSVs.

You can find documentation on those here:

http://dev.mysql.com/doc/mysql/en/load-data.html
http://dev.mysql.com/doc/mysql/en/mysqlimport.html

Kind Regards,

Lachlan Mulcahy, Melbourne, Australia
MySQL AB, www.mysql.com
Are you MySQL certified? www.mysql.com/certification