데브포유

# 몽고디비 인덱스 :인덱스명은 자동생성되며, 인덱스명으로 제어는 불가능함. >> 생성db.컬렉션.createIndex() >> 조회db.컬렉션.getIndexes() >> 삭제db.컬렉션.dropIndex() or dropIndexes()db.runCommnad({dropIndex:'emp', index:{eno:-1}}) >> 인덱스 재생성db.컬렉션.reIndex() >> 실습 (1:오름차순, -1:내림차순) db.employees.createIndex({comm:1}) db.employees.getIndexes() db.employees.reIndex() db.employees.createIndex({empno:1}) -- 싱글키 인덱스 db.employees.createIndex({empno:1..

Aggregation Pipeline OperatorsOn this pageStage OperatorsExpression OperatorsAccumulatorsNOTEFor details on specific operator, including syntax and examples, click on the specific operator to go to its reference page.Stage OperatorsIn the db.collection.aggregate method, pipeline stages appear in an array. Documents pass through the stages in sequence.db.collection.aggregate( [ { }, ... ] ) NameD..

The following modifiers are available for use in update operations; e.g. in db.collection.update() and db.collection.findAndModify().Specify the operator expression in a document of the form:{ : { : , ... }, : { : , ... }, ... } NOTEFor details on specific operator, including syntax and examples, click on the specific operator to go to its reference page.Update OperatorsFieldsNameDescription$inc..

Query SelectorsComparisonFor comparison of different BSON type values, see the specified BSON comparison order.NameDescription$eqMatches values that are equal to a specified value.$gtMatches values that are greater than a specified value.$gteMatches values that are greater than or equal to a specified value.$ltMatches values that are less than a specified value.$lteMatches values that are less t..

SQL Terms, Functions, and ConceptsMongoDB Aggregation OperatorsWHERE$matchGROUP BY$groupHAVING$matchSELECT$projectORDER BY$sortLIMIT$limitSUM()$sumCOUNT()$sumjoin$lookupNew in version 3.2.ExamplesThe following table presents a quick reference of SQL aggregation statements and the corresponding MongoDB statements. The examples in the table assume the following conditions:The SQL examples assume t..

# Aggregation FrameWrok db.employees.find().pretty(); db.employees.aggregate({$match : { $and: [{deptno: 10},{sal : {$gte: 500, $lte:3000}}]}},{$match : { $or: [{job:"CLERK"},{job:"SALESMAN"}]}},{$project :{ _id : 0, empno : 1, ename : {$toLower :"$ename"}, substr_nm : {$substr: ["$ename",1,2]} }}).pretty() >> comm필드를 서브다큐먼트로 저장db.employees.aggregate({$match : {deptno:30}},{$project: {_id : 0,em..

# 데이터 타입# objectid는 24자리, 사용자가 직접 지정하는 것은 권장하지 않음. p = { "_id" : ObjectId("201703210012345678901201"), "v_date" : ISODate("2017-03-21T15:00:00"),"v_bin" : BinData(0,"2222"),"v_char" : "moonsun","v_num" : 1234567,"v_arr" : ["www.naver.com","www.google.com"],"v_bignum" : NumberLong(12345)} db.data_att.save(p)db.data_att.find() - EOF -

# 데이터 입력/수정/삭제 > use tset> m={ ename : "smith"}> db.things.save(m)> db.things.insert({empno:1101, ename:"king"})> db.things.find()> for(var n=1103; n db.things.find({empno:1101})> db.things.update({empno:1101},{$set:{ename:"test"}})> db.things.remove({})> db.things.drop() -EOF -