mysql导出csv

mysql导出
set names utf8;
--selrct ... into outfile
select id,val from st limit 5 into outfile './st1.csv' CHARACTER SET 'utf8' fields terminated by ',' enclosed by "";


mysql导入
load data infile './st.csv' into table st1 CHARACTER SET 'utf8' fields  terminated by ',' enclosed by "" (id,value);