数据库资源不正经程序员06-编程day05mongodb json2其他database第五天

学习 复 createtablestudent(idINT(11)primarykeyauto_increment,namevarchar(20)unique,passwdvarchar(15)notnull,claINT(11),constraintstu_cla_FKforeignkey(cla)references初始化连接….do 关闭连接mysql_close/usr/local/mongodb/bin/mongod--configpcremongodb 2007年10gen推出的产品primarymongodb--mongodb库的 show @localhostday05]$mongolocalhost:27017/mydb1MongoDBsversion:2.6.10connectingto:>登陆指令总结：mongo切换或创建库>useswitchedtodbuse>>show>show新增 新增一个文档biancheng是集合 >db.biancheng.find() :'woman',like:['','花生 save与insert的区格式:db.SRC_COLL.find().forEach(function(x){db.NEW_COLL.insert(x)}db.biancheng.find().forEach(function(x){上述反复执行，只会插入一database8查看文 语法查看巴萨队内全部球员DBQuery.s BatchSizeselect*fromBarca; 查看的详细信息select*fromBarcawhere查看为29,并且是踢中后卫(pos为CB)的球员select*fromBarcawhereage=24andpos='MF';$gtgreaterthan$lt=lessthan$lte=lessthanequal$gtegreaterthanequal$nenotequaldb.Barca.find({age:{$gt:25},pos:'MF'db.Barca.findage:{$gt:25},pos:'MFpretty()显示球员的不同selectdistinctagefromBarca;显示是24或者29的球员信息select*fromBarcawhereage=24orage=29;db.Barca.find({$or:[{age:24},{age:29}]})db.Barca.find({显示不是24或者29的球员信息db.Barca.find({age:{$nin:[24,29]}})显示位置为空的球员信息posisnulldb.Barca.find({pos:null})修改 {upsert:<boolean>,multi:<boolean>,writeConcern:writeConcern:})updateBarcasetcolumn1=val1where>WriteResult({"nMatched":1,"nUpserted":0,"nModified":1 的位置修改为ull将vhalirvic的改为25岁,位置改成SB将pos为null的球员信息修改为pos=MF删除 {justOne:writeConcernwriteConcern:>})justOne是否只删除一个，默认是false默认使用WriteConcern.NORMAL仅仅抛出网络异常索 >{"numIndexesBefore":1,"numIndexesAfter":"ok":}{"isMultiKey":false,"n":"nscannedObjects":"nscanned":22,"nscannedObjectsAllns":22,"nscannedAllns":22,"scanAndOrder":false,"indexOnly":false,"nYields":"nChunkSkips":"millis":"server":"localhost.local:27017","filterSet":false}{"cursor":"BtreeCursorname_1","isMultiKey":false,"n":"nscannedObjects":"nscanned":1,"nscannedObjectsAllns":1,"nscannedAllns":1,"scanAndOrder":false,"indexOnly":false,"nYields":"nChunkSkips":"millis":0,"name"[]]"server":"localhost.local:27017","filterSet":false}name_1”表示使用了name上的索引；)“millis”：本次查询花费的毫秒数，数字越小说明查>{"nIndexesWas":2,"ok":1聚合 --求各个位置的最小selectpos,min(age)minagefromBarcagroupbyposdb.Barca.aggregate({$group:{_id:"$pos",minage:{$min:"$age"}}})db.Barca.aggregate({$group:{_id:"$pos",maxage:{$max:"$age"}}db.Barca.aggregate({$group:{_id:"$pos",avgage:{$avg:"$age"}}--求各个位置的db.Barca.aggregate({$group:{_id:"$pos",sumage:{$sum:"$age"}}--统计各个位置的人数selectcount(*),posfromBarcagroupbypos;db.Barca.aggregate({$group:{_id:"$pos",count:{$sum:1}}})--统计不同位置不同的人数groupBydb.Barca.aggregate({$group:{_id:{age:"$age",pos:"$pos"},count:{$sum:1}}副本集 DBConnection(bool_autoReconnect=false,DBReplicaSet*cp=0,double_autoReconnect是否自动重连，默认cpso_timeout超时时间，单位是秒boolconnect(constchar*hostname,string&hostname127.0.0.1,errmsgvoidremove(conststring&ns,Queryq,booljustOne=0nsqjustOne是否删除一条，默认QueryQuery(constchar*json);建议使建议使 用 是voidinsert(conststring&ns,BSONObjobj,intnsBSONObjobjBSONObjBuilder可以构造append(constStringData&fieldName,constcharBSONObjobj()可以返回BSONObj/**UseBSONmacrotobuildaBSONObjfromaBSON("name"<<"joe"<<"age"<<33withauto-generatedobjectBSON(GENOID<<"name"<<"joe"<<"age"<<33ThelabelsGT,GTE,LT,LTE,NEcanbehelpfulforstream-orientedconstructionofaBSONObj,part