LOAD DATA INFILE 'contacts.csv' INTO TABLE CONTACTS FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS ( FNAME POSITION(1) CHAR, LNAME POSITION(2) CHAR )