CSV to Mysql
This Php Script Will Import very large CSV files to MYSQL database in a minute
Instructions
1. Keep this php file and Your csv file in one folder2. Create a table in your mysql database to which you want to import
3. Open the php file from your localhost server
4. Enter all the fields
5. click on upload button
Facing Problems ? Some of the reasons can be the ones shown below
1) Check if the table to which you want to import is created and the datatype of each column matches with the data in csv2) If fields in your csv are not separated by commas go to Line 117 of php file and change the query
3) If each tuple in your csv are not one below other(i.e not seperated by a new line) got line 117 of php file and change the query