Dec 2, 2006

Various Issues, Tips and Methods

Thanks for visiting.

2 Comments:

Anonymous said...: "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; February 21, 2007
Satya Prakash said...: 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.; February 22, 2007

Subscribe to: Post Comments (Atom)