把mysql數(shù)據(jù)導(dǎo)出到文本，用“，”分割
來源：懂視網(wǎng)
責(zé)編：小采
時間：2020-11-09 14:10:11
把mysql數(shù)據(jù)導(dǎo)出到文本，用“，”分割
把mysql數(shù)據(jù)導(dǎo)出到文本，用，分割:$ 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.22
導(dǎo)讀把mysql數(shù)據(jù)導(dǎo)出到文本，用，分割:$ 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.22
$ 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 << EOF > aa.txt
select concat(UserGuid,',',CreditLine/10000,',',AvailableFunds/10000,',',LockedFunds/10000) from KyPayAccounts where CreditLine>0;
EOF
聲明：本網(wǎng)頁內(nèi)容旨在傳播知識，若有侵權(quán)等問題請及時與本網(wǎng)聯(lián)系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com
把mysql數(shù)據(jù)導(dǎo)出到文本，用“，”分割
把mysql數(shù)據(jù)導(dǎo)出到文本，用，分割:$ 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.22
