how to load large amount of data?

Ryder · #1 08-24-2006, 05:17 AM

Hello Everyone
I have a data file in csv format with over millions reords. there are 14 columns. Is there any command to load the data directly into database?
how to load that much amount of data in small amount of time into the database?
Thanks! -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

Saggie · #2 08-24-2006, 05:18 AM

you must try the LOAD DATA [LOCAL] INFILE command.

This is a very efficient way to bulk-load data. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --