$ 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 creditline0; eof
$ cat t1.sh
mysql -h 172.24.0.220 -uquery -pquery che001 -nb aa.txt
select concat(userguid,',',creditline/10000,',',availablefunds/10000,',',lockedfunds/10000) from kypayaccounts where creditline>0;
eof