[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