heidsoft
commented
1 year ago mongo 操作
test> db.fruit.insertOne({name:"apple"})
{
acknowledged: true,
insertedId: ObjectId("646395aa81b3c85a01a2ad46")
}
test> show collections;
fruit
test> db.fruit.find();
[ { _id: ObjectId("646395aa81b3c85a01a2ad46"), name: 'apple' } ]
test> db.fruit.find();
[ { _id: ObjectId("646395aa81b3c85a01a2ad46"), name: 'apple' } ]
test> db.fruit.drop();
true
test> db.fruit.find();
test> db.fruit.insertOne({name:"apple",from:{ country:"China",province:"Shanghai"}})
{
acknowledged: true,
insertedId: ObjectId("6463984f81b3c85a01a2ad47")
}
test> db.fruit.find();
[
{
_id: ObjectId("6463984f81b3c85a01a2ad47"),
name: 'apple',
from: { country: 'China', province: 'Shanghai' }
}
]
test> db.fruit.find({"from.country":"Shanghai"});
test> db.fruit.find({"from.country":"Chine"});
test> db.fruit.find({"from.country":"China"});
[
{
_id: ObjectId("6463984f81b3c85a01a2ad47"),
name: 'apple',
from: { country: 'China', province: 'Shanghai' }
}
]
test> db.fruit.find({"from": {country:"China"});
Uncaught:
SyntaxError: Unexpected token, expected "," (1:40)
> 1 | db.fruit.find({"from": {country:"China"});
| ^
2 |
test> db.fruit.find({"from": {country:"China"}});
test> db.fruit.insert([{"name":"Apple",color:["red","green"]},]);
DeprecationWarning: Collection.insert() is deprecated. Use insertOne, insertMany, or bulkWrite.
{
acknowledged: true,
insertedIds: { '0': ObjectId("646399cf81b3c85a01a2ad48") }
}
test> db.fruit.find({"from": {country:"China"}});
test> db.fruit.find();
[
{
_id: ObjectId("6463984f81b3c85a01a2ad47"),
name: 'apple',
from: { country: 'China', province: 'Shanghai' }
},
{
_id: ObjectId("646399cf81b3c85a01a2ad48"),
name: 'Apple',
color: [ 'red', 'green' ]
}
]
test> db.fruit.insert([{"name":"Apple",color:["red","green"]},{"name":"Mongo",color:["yellow","green"]}]);
{
acknowledged: true,
insertedIds: {
'0': ObjectId("64639a1981b3c85a01a2ad49"),
'1': ObjectId("64639a1981b3c85a01a2ad4a")
}
}
test> db.fruit.find();
[
{
_id: ObjectId("6463984f81b3c85a01a2ad47"),
name: 'apple',
from: { country: 'China', province: 'Shanghai' }
},
{
_id: ObjectId("646399cf81b3c85a01a2ad48"),
name: 'Apple',
color: [ 'red', 'green' ]
},
{
_id: ObjectId("64639a1981b3c85a01a2ad49"),
name: 'Apple',
color: [ 'red', 'green' ]
},
{
_id: ObjectId("64639a1981b3c85a01a2ad4a"),
name: 'Mongo',
color: [ 'yellow', 'green' ]
}
]
test> db.fruit.find({color:"red"});
[
{
_id: ObjectId("646399cf81b3c85a01a2ad48"),
name: 'Apple',
color: [ 'red', 'green' ]
},
{
_id: ObjectId("64639a1981b3c85a01a2ad49"),
name: 'Apple',
color: [ 'red', 'green' ]
}
]
test> db.fruit.find({$or:[{color:"red"},{color:"yellow"}]});
[
{
_id: ObjectId("646399cf81b3c85a01a2ad48"),
name: 'Apple',
color: [ 'red', 'green' ]
},
{
_id: ObjectId("64639a1981b3c85a01a2ad49"),
name: 'Apple',
color: [ 'red', 'green' ]
},
{
_id: ObjectId("64639a1981b3c85a01a2ad4a"),
name: 'Mongo',
color: [ 'yellow', 'green' ]
}
]
test> db.fruit.find()
[
{
_id: ObjectId("6463984f81b3c85a01a2ad47"),
name: 'apple',
from: { country: 'China', province: 'Shanghai' }
},
{
_id: ObjectId("646399cf81b3c85a01a2ad48"),
name: 'Apple',
color: [ 'red', 'green' ]
},
{
_id: ObjectId("64639a1981b3c85a01a2ad49"),
name: 'Apple',
color: [ 'red', 'green' ]
},
{
_id: ObjectId("64639a1981b3c85a01a2ad4a"),
name: 'Mongo',
color: [ 'yellow', 'green' ]
}
]
test> db.fruit.find({name:"Mongo"},{_id:0,color:1});
[ { color: [ 'yellow', 'green' ] } ]
test>
test> db.fruit.updateOne({name:"apple"},{$set:{from:"China2"}});
{
acknowledged: true,
insertedId: null,
matchedCount: 1,
modifiedCount: 1,
upsertedCount: 0
}
test> db.fruit.find()
[
{
_id: ObjectId("6463984f81b3c85a01a2ad47"),
name: 'apple',
from: 'China2'
},
{
_id: ObjectId("646399cf81b3c85a01a2ad48"),
name: 'Apple',
color: [ 'red', 'green' ]
},
{
_id: ObjectId("64639a1981b3c85a01a2ad49"),
name: 'Apple',
color: [ 'red', 'green' ]
},
{
_id: ObjectId("64639a1981b3c85a01a2ad4a"),
name: 'Mongo',
color: [ 'yellow', 'green' ]
},
{ _id: ObjectId("64639d7a81b3c85a01a2ad4b"), name: 'apple' },
{ _id: ObjectId("64639d7a81b3c85a01a2ad4c"), name: 'pear' },
{ _id: ObjectId("64639d7a81b3c85a01a2ad4d"), name: 'orange' }
]
https://www.mongodb.com/docs/manual/tutorial/install-mongodb-on-ubuntu/