gistfile1.sql

LOAD DATA LOCAL INFILE '/home/ubuntu/dev/5016/csv/customers.csv' INTO TABLE tmp_5016
	FIELDS TERMINATED BY ',' 
		ENCLOSED BY '"'
	lines terminated by '\n' 
		(client_id, name, @first_name, @last_name, title, phone1, @c1, fax1, email, 
			address1, address2, city, state, zip, phone2, fax2)
	set
		first_name = if(length(@first_name) = 0, null, first_name),
		last_name = if(length(@last_name) = 0, null, last_name),
		location_id = null;