CREATE TEMPORARY TABLE tmp_Client ( `number` varchar(255) NOT NULL, `name` varchar(255) NOT NULL ); LOAD DATA LOCAL INFILE '/home/cfis/t150/01-clients.csv' #LOAD DATA LOCAL INFILE '/home/borey/public_html/carleyfoundry/trunk/import/t150/01-clients.csv' REPLACE INTO TABLE `tmp_Client` FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' IGNORE 1 LINES; TRUNCATE TABLE cf_Client; INSERT INTO cf_Client (`number`, `name`, `added`, `changed`) SELECT `number`, `name`, NOW(), NOW() FROM tmp_Client ORDER BY 0 + `number`;