/etc/my.cnf
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
重启mysql
mysql -uroot -pxxx -e"select id,nickname,level,rmb from db.table where rmb > 0" > ~/result.sql
/etc/my.cnf
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
character-set-server=utf8
重启mysql
mysql -uroot -pxxx -e"select id,nickname,level,rmb from db.table where rmb > 0" > ~/result.sql