查询 roo char def bsp con rom 编码
#!/bin/shcd /d/compareMYSQL="mysql -h -uroot -p**** --default-character-set=utf8 -A";sql="select * from contrast.dx_record limit 0,10 ";$MYSQL -e "$sql" >dx.xlsecho "end";
转换编码的指令
iconv -f utf-8 -t gb2312 dx.xls>compare1.xls
shell将sql查询结果存放到excel中
来源: http://www.bubuko.com/infodetail-2093271.html