Wiki Follow @yiiframework

hi, Here i am giving you some simple step to import huge data from a csv file to your mysql table.this is useful when you have a very huge data to import from csv format.

When we are doing an insert of huge no.of rows into an SQL table ,Normally we will try to write separate insert quries this may lead us to a long duration of execution time and we can increase the speed of executing SQL quries by adding all the rows into a single insert query.

Original source code and idea are from: PHP, PDO & Nested Transactions.

This article will discuss how to setup your web development environment with the following specifications:

Speedup unit tests by moving MySql data to memory [Ubuntu]