Blog for Web Developers.
Dec 2, 2006
"Read sql data from a large file/csv file at very high speed"There is a very handy type of insert in MySQL called LOAD DATA INFILE which does this task for you much faster than any php code.LOAD DATA LOCAL INFILE '/path/to/file.txt'INTO TABLE my_sql_table FIELDS TERMINATED BY ','LINES STARTING BY '' TERMINATED BY '\n'Check out the mysql documentation on this feature: http://dev.mysql.com/doc/refman/5.0/en/load-data.html
Right!But in my case I have to provide a web page for a developer user who will take download file from maxmind and enter here.
Post a Comment