1 列出并選用
1.1 列出所有數(shù)據(jù)庫(kù)
> show dbs local 0.000GBmyblog 0.000GB
1.2 使用某個(gè)數(shù)據(jù)庫(kù)
> use myblogswitched to db myblog
1.3 列出所有集合
> show collectionsarticlesreplicationColletionsessionsuserswangduanduan
2 插入數(shù)據(jù) insert(value)
// 在已經(jīng)存在的集合中插入數(shù)據(jù)> db.users.insert({name:'hh',age:23})Inserted 1 record(s) in 43ms// 在不存在的集合中插入數(shù)據(jù),集合不存在則自動(dòng)創(chuàng)建集合并插入> db.students.insert({name:'hh',age:23})Inserted 1 record(s) in 72ms3 查詢 find(option)
3.1 查詢集合里所有的文檔
> db.users.find()/* 1 */{ "_id" : ObjectId("583e908453be942d0c5419dc"), "login_name" : "wangduanduan", "password" : "wrong age"}/* 2 */{ "_id" : ObjectId("583ed2a5cc9a937db049616d"), "login_name" : "hh", "password" : "sdfsdf"}/* 3 */{ "_id" : ObjectId("583fb2e9b12f8b7a7aa37572"), "name" : "wangduanduan", "age" : 34.0}/* 4 */{ "_id" : ObjectId("583fb707b12f8b7a7aa37573"), "name" : "hh", "age" : 23.0}3.2 按條件查詢文檔
> db.users.find({name:'wangduanduan'})/* 1 */{ "_id" : ObjectId("583fb2e9b12f8b7a7aa37572"), "name" : "wangduanduan", "age" : 34.0}注意
// 這是錯(cuò)的，查不到結(jié)果> db.users.find({_id:'583fb2e9b12f8b7a7aa37572'})Fetched 0 record(s) in 1ms// 這是正確的> db.users.find({_id:ObjectId('583fb2e9b12f8b7a7aa37572')})/* 1 */{ "_id" : ObjectId("583fb2e9b12f8b7a7aa37572"), "name" : "wangduanduan", "age" : 34.0}3.3 查詢集合內(nèi)文檔的個(gè)數(shù)
> db.users.count()4
3.4 比較運(yùn)算符
$gt: 大于
$gte: 大于等于
$lt: 小于
$lte: 小于等于
$ne: 不等于
// 查詢用戶里年齡大于30歲的人， 其他條件以此類(lèi)推> db.user.find({age:{$gt:30}})/* 1 */{ "_id" : ObjectId("583fb2e9b12f8b7a7aa37572"), "name" : "wangduanduan", "age" : 34.0}3.5 邏輯運(yùn)算符
3.5.1 與
// 查詢名字是wangduanduan,age=34的用戶> db.users.find({name:'wangduanduan',age:34})/* 1 */{ "_id" : ObjectId("583fb2e9b12f8b7a7aa37572"), "name" : "wangduanduan", "age" : 34.0}3.5.2 $in 或
// 查詢名字是wangduanduan,或hh的用戶> db.users.find({name:{$in:['wangduanduan','hh']}})/* 1 */{ "_id" : ObjectId("583fb2e9b12f8b7a7aa37572"), "name" : "wangduanduan", "age" : 34.0}3.5.3 $nin 非
// 查詢名字不是wangduanduan或者h(yuǎn)h的用戶> db.users.find({name:{$nin:['wangduanduan','hh']}})/* 1 */{ "_id" : ObjectId("583e908453be942d0c5419dc"), "login_name" : "wangduanduan", "password" : "wrong age"}/* 2 */{ "_id" : ObjectId("583ed2a5cc9a937db049616d"), "login_name" : "hh", "password" : "sdfsdf"}3.6 正則匹配
// 查詢名字是中含有duan的用戶> db.users.find({name:/duan/})/* 1 */{ "_id" : ObjectId("583fb2e9b12f8b7a7aa37572"), "name" : "wangduanduan", "age" : 34.0}/* 2 */{ "_id" : ObjectId("583fc919b12f8b7a7aa37575"), "name" : "wangduanduan", "age" : 45.0}3.7 大招$where
// 返回含有l(wèi)ogin_name字段的文檔db.getCollection('users').find({$where:function(){ return !!this.login_name;}})4 更新 update();
4.1 整體更新
> db.users.update({login_name:'wangduanduan'},{name:'heihei',age:34})
Updated 1 existing record(s) in 116ms
4.2 $set 局部更新
// 只是將用戶年齡設(shè)置成101> db.users.update({name:'wangduanduan'},{$set:{age:101}})
4.3 $inc
// 將用戶年齡增加1歲，如果文檔沒(méi)有age這個(gè)字段，則會(huì)增加這個(gè)字段> db.users.update({name:'wangduanduan'},{$inc:{age:1}})
4.3 upsert操作
// 如果查不到文檔，則增加文檔> db.users.update({name:'nobody'},{$inc:{age:1}},true)Updated 1 new record(s) in 3ms
/* 6 */
{
"_id" : ObjectId("583fd20f2cfa6a4817c4171c"),
"name" : "nobody",
"age" : 1.0
}
4.4 批量更新
// upadate 的第四個(gè)參數(shù)設(shè)置成true的時(shí)候，就會(huì)批量更新> db.users.update({name:'wangduanduan'},{$set:{age:1891}},false,true)
5 刪除
// 刪除某些文檔db.person.remove({"name":"joe"})
// 刪除整個(gè)集合db.person.remove()
新聞熱點(diǎn)
疑難解答
圖片精選
