mysql> LOAD DATA LOCAL INFILE '/home/ozgun/dosya.csv' INTO TABLE species FIELDS TERMINATED BY ':' OPTIONALLY ENCLOSED BY '"' (col1,col2,col3);
mysql> LOAD DATA INFILE '/home/ozgun/dosya.csv' INTO TABLE species FIELDS TERMINATED BY ':' OPTIONALLY ENCLOSED BY '"';
Veri aktarılacak dosyadaki satırlar da şu şekilde:
"s1s1":"s1s2":"s1s3" "s2s1":"s2s2":"s2s3"