note 69133 deleted from function.fgetcsv by danbrown
| From: | danbrown@php.net | Date: | Sun, 17 May 2009 18:15:46 +0000 |
| Subject: | note 69133 deleted from function.fgetcsv by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-155088@lists.php.net to get a copy of this message | ||
Note Submitter: Skakunov Alexander <i1t2b3 at gmail dot com>
----
If you need to import a huge CSV file into a database, use the bulk insert technique instead of many
line-by-line inserts:
- MSSQL: bcp tool and "BULK INSERT" SQL
- MySQL: mysqlimport tool and "LOAD DATA INFILE" SQL
As for MySQL, you can use the ready "Quick CSV import" class at http://a4.users.phpclasses.org/browse/package/2917.html