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