mysql 导出csv格式数据解决乱码
#导出
root@95d956bb2012:/# mysql -u root -p -e "select * from wordpress.wp_users" |sed 's/ /","/g;s/^/"/;s/$/"/;s/
//g' > /tmp/wp_users.csv
#解决乱码
sed -i '1s/^/xEFxBBxBF/' /tmp/wp_users.csv
#导出
root@95d956bb2012:/# mysql -u root -p -e "select * from wordpress.wp_users" |sed 's/ /","/g;s/^/"/;s/$/"/;s/
//g' > /tmp/wp_users.csv
#解决乱码
sed -i '1s/^/xEFxBBxBF/' /tmp/wp_users.csv