ATE TABLE t1; LOAD DATA LOW_PRIORITY INFILE '../../tmp/t1.dat' INTO TABLE t1 FIELDS ENCLOSED BY '"' OPTIONALLY ENCLOSED BY ':' LINES TERMINATED BY '\r\n'; SELECT * FROM t1 ORDER BY c1; c1 c2 c3 1 abc