<div class="codebody" id="code54964"> load data infile '/tmp/file.csv' into table _tablename (set character utf8) fields terminated by ',' enclosed by '"' lines terminated by '\r\n';
<div class="codebody" id="code46678"> select * from tablename into outfile '/tmp/data.txt' fields terminated by ',' optionally enclosed by '"' lines terminated by '\n';
