把mysql数据导出到文本,用“,”分割

2015-02-03 10:03:36 · 作者: · 浏览: 11
$ cat t1.sh
mysql -h 172.24.0.220 -uquery -pquery che001 -NB << EOF > aa.txt
select concat(UserGuid,',',CreditLine/10000,',',AvailableFunds/10000,',',LockedFunds/10000) from KyPayAccounts where CreditLine>0;
EOF
\