tmp/t1.dat' FIELDS ENCLOSED BY '"' OPTIONALLY ENCLOSED BY ':' LINES TERMINATED BY '\r\n' FROM t1; SELECT * FROM t1 ORDER BY c1; c1 c2 c3 1 abc