NYCPHP Meetup

NYPHP.org

[nycphp-talk] importing 650,000 records

Rolan Yang rolan at omnistep.com
Sat Dec 31 13:07:41 EST 2005


I would import the file into a temporary table, then run a query to 
separate and insert data into the appropriate tables/fields afterwards. 
MySQL is pretty fast at doing that stuff.

~Rolan

Joseph Crawford wrote:

> can mysql import a csv file and will it allow me to import to 2 
> different tables?
> one way or another i would have to get it into a format importable by 
> mysql :)
>



More information about the talk mailing list