mongo/mysql , 欄位添加"-00",mongo-00
============================================================Phil-PROD-20141212,欄位添加"-00"=========
現需要對線上墊付寶資料與輕易貸關聯的資料有問題的資料進行修改(批量)
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';