首页 > 代码库 > mongo/mysql , 字段添加"-00"
mongo/mysql , 字段添加"-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‘;
mongo/mysql , 字段添加"-00"
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。