Re: Loading CSV data into MySQL

On Sunday 02 February 2003 23:10, John W. Holmes wrote: > Then don't use LOAD DATA INFILE if it's not working for you. Write a PHP > script to read each line of the file and insert it. Yes, it'll be a > little slower, but then you could also add an auto_increment or > timestamp field that'll keep track of how things were inserted... Even then, do note that once you start deleting records your carefully ordered tables will soon have to be re-ordered. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-general ------------------------------------------ /* "God is a comedian playing to an audience too afraid to laugh." - Voltaire */