in reply to Convert CSV export from Outlook to MySQL
If you are using MySQL, know then that there is a native MySQL function which would do exactly what you want.
From the MySQL documentation:
LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name.txt' [REPLACE | IGNORE] INTO TABLE tbl_name [FIELDS [TERMINATED BY '\t'] [[OPTIONALLY] ENCLOSED BY ''] [ESCAPED BY '\\' ] ] [LINES TERMINATED BY '\n'] [IGNORE number LINES] [(col_name,...)]
The LOAD DATA INFILE statement reads rows from a text file into a table at a very high speed.
Check the documentation of MySQL to find more about it.
CountZero
"If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law
|
|---|