mongo/mysql,字段添加"-00"

============================================================Phil-PROD-20141212，字段添加-00========= 現(xiàn)需要對線上墊付寶數(shù)據(jù)與輕易貸關(guān)聯(lián)的數(shù)據(jù)有問題的數(shù)據(jù)進(jìn)行修改（批量） mongodb bindingloan 需要對 loanAccountId后加 ‘-00’ MySql需要將 selec

============================================================ Phil-PROD-20141212，字段添加"-00" =========
現(xiàn)需要對線上墊付寶數(shù)據(jù)與輕易貸關(guān)聯(lián)的數(shù)據(jù)有問題的數(shù)據(jù)進(jìn)行修改（批量）
mongodb
bindingloan
需要對 loanAccountId后加 ‘-00’

MySql 需要將 select LoanAccountId from KyPayAccounts
LoanAccountId 后沒有-00的 記錄加上 ‘-00’
========================= mongo ====== db.bindingloan.find({},{"loanAccountId":1}).pretty()
db.bindingloan.find({"loanAccountId" :{$not:/\-00$/}},{"loanAccountId":1}).pretty()
mongodump --host localhost --port 27020 -uquery -pquery -d che001 -c bindingloan -o ./ mongorestore --drop --host localhost --port 27017 -uplatform -pplatform -d che001 -c bindingloan bindingloan.bson

var userf=db.bindingloan.find({"loanAccountId" :{$not:/\-00$/}},{"loanAccountId":1}); while(userf.hasNext()){ var userft=userf.next(); var useid=userft._id; var uname=userft.loanAccountId; var usename=uname+"-00"; db.bindingloan.save({"_id":useid,"loanAccountId":usename}) print(usename);}

========================= mysql ======
mysqldump -uquery -pquery -h172.24.0.220 --lock-tables=false --single-transaction --default-character-set=utf8 --set-gtid-purged=OFF che001 KyPayAccounts> KyPayAccounts.sql
SELECT CONCAT(LoanAccountId,'-00') FROM KyPayAccounts WHERE LoanAccountId IS NOT NULL AND LoanAccountId NOT LIKE '%-00';
UPDATE KyPayAccounts SET LoanAccountId=CONCAT(LoanAccountId,'-00') WHERE LoanAccountId IS NOT NULL AND LoanAccountId NOT LIKE '%-00';

聲明：本網(wǎng)頁內(nèi)容旨在傳播知識，若有侵權(quán)等問題請及時與本網(wǎng)聯(lián)系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com