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`;