mongodb 常用命令及增删改查

显示所有数据库

# 显示所有数据库
show databases
show dbs

切换数据库

# 切换数据库，没有则创建
use admin

显示当前数据库

# 显示当前数据库
db

显示当前数据库的表

# mongo中collection即为 表
# 显示当前数据库的表
show collections
show tables

创建用户

# 创建用户
db.createUser(
	{
		user:"root",
		pwd:"123456",
		roles:[{role:"userAdminAnyDatabase",db:"admin"}]
	}
);
db.system.users.find().pretty()

更新用户

# 更新用户
db.updateUser('root',
	{
		pwd:"123456",
		roles:[{role:"userAdminAnyDatabase",db:"admin"}]
	}
);
db.system.users.find().pretty()

删除用户

# 删除用户
db.dropUser('root')
db.system.users.find().pretty()

授权数据库给用户

# 授权数据库给用户
db.auth('root', '123456')

显示当前数据的用户

# 显示当前数据的用户
show users

显示全局所有数据库的用户

# 显示所有数据库的用户
db.system.users.find().pretty()

增删改查

增

#======================================
#1、创建
#======================================

db.Books.insert({"name":"战争与和平"});
db.Books.insert([
{"name":"斗罗大陆"},
{"name":"斗罗大陆·绝世唐门"}]);

db.Books.insertOne({"name":"星辰变"});
db.Books.insertMany([
{"name":"莽荒纪"},
{"name":"兽血沸腾"}]);

db.Books.find();
db.Books.remove({});

删

#======================================
#2、删除
#======================================

db.Books.insert([
{"name":"斗罗大陆"},
{"name":"斗罗大陆·绝世唐门"},
{"name":"斗破苍穹"}]);
db.Books.find();

db.Books.deleteOne({"name":/斗/});
db.Books.find();

db.Books.deleteMany({"name":/斗/});
db.Books.find();

#============

db.Books.insert([
{"name":"九星毒奶"},
{"name":"神元星"},
{"name":"星之誓约者"}]);
db.Books.find();

db.Books.remove({"name":/星/},{justOne:true});
db.Books.find();

db.Books.remove({"name":/星/})
db.Books.find();

改

#======================================
#3、修改
#======================================

#updateOne
db.Books.insert([
{"name":"斗罗大陆"},
{"name":"斗罗大陆·绝世唐门"},
{"name":"斗破苍穹"}]);
db.Books.find();

db.Books.updateOne(
{"name":/斗/},
{$set:{"name":"校花的贴身保镖","price":99.8}});
db.Books.find();

db.Books.remove({});

#updateMany
db.Books.insert([
{"name":"斗罗大陆"},
{"name":"斗罗大陆·绝世唐门"},
{"name":"斗破苍穹"}]);
db.Books.find();

db.Books.updateMany(
{"name":/斗/},
{$set:{"name":"校花的贴身保镖","price":99.8}});
db.Books.find();

db.Books.remove({});

#replaceOne
db.Books.insert([
{"name":"斗罗大陆"},
{"name":"斗罗大陆·绝世唐门"},
{"name":"斗破苍穹"}]);
db.Books.find();

db.Books.replaceOne(
{"name":/斗/},
{"name":"校花的贴身保镖","price":99.8});
db.Books.find();

db.Books.remove({});

#update
#默认只更新一个文档，如果需要更新多个则需要设置multi=true
db.Books.insert([
{"name":"斗罗大陆"},
{"name":"斗罗大陆·绝世唐门"},
{"name":"斗破苍穹"}]);
db.Books.find();

db.Books.update(
{"name":/斗/},
{$set:{"name":"校花的贴身保镖","price":99.8}});
db.Books.find();

db.Books.remove({});

#======================================
#4、修改方式详讲
#======================================

#$currentDate

db.Books.insert([
{"name":"斗罗大陆","lastReadDate":Date(),"lastReadTimeSpan":123},
{"name":"斗罗大陆·绝世唐门","lastReadDate":Date(),"lastReadTimeSpan":123},
{"name":"斗破苍穹","lastReadDate":Date(),"lastReadTimeSpan":123}]);
db.Books.find();

db.Books.update(
{"name":"斗罗大陆"},
{$currentDate:{"lastReadDate":true,"lastReadTimeSpan":{$type:"timestamp"}}});
db.Books.find();

db.Books.update(
{"name":"斗罗大陆·绝世唐门"},
{$currentDate:{"lastReadDate":true,"lastReadTimeSpan":{$type:"date"}}});
db.Books.find();

db.Books.remove({});


#$inc

db.Books.insert([
{"name":"斗罗大陆","recordCount":200},
{"name":"斗罗大陆·绝世唐门","recordCount":1},
{"name":"斗破苍穹","recordCount":1}]);
db.Books.find();

db.Books.update({"name":"斗罗大陆"},{$inc:{"recordCount":1}});
db.Books.find();

db.Books.update({"name":"斗罗大陆"},{$inc:{"recordCount":10}});
db.Books.find();

db.Books.remove({});

#$min

db.Books.insert([
{"name":"斗罗大陆","price":200},
{"name":"斗罗大陆·绝世唐门","price":200},
{"name":"斗破苍穹","price":200}]);
db.Books.find();

db.Books.update({"name":"斗罗大陆"},{$min:{"price":99.8}});
db.Books.find();

db.Books.update({"name":"斗罗大陆"},{$min:{"price":99.8}});
db.Books.find();

db.Books.remove({});

#$max

db.Books.insert([
{"name":"斗罗大陆","price":99.8},
{"name":"斗罗大陆·绝世唐门","price":99.8},
{"name":"斗破苍穹","price":99.8}]);
db.Books.find();

db.Books.update({"name":"斗罗大陆"},{$max:{"price":200}});
db.Books.find();

db.Books.update({"name":"斗罗大陆"},{$max:{"price":99.8}});
db.Books.find();

db.Books.remove({});

#$mul

db.Books.insert([
{"name":"斗罗大陆","price":99.8},
{"name":"斗罗大陆·绝世唐门","price":99.8},
{"name":"斗破苍穹","price":99.8}]);
db.Books.find();

db.Books.update({"name":"斗罗大陆"},{$mul:{"price":0.98}});
db.Books.find();

db.Books.remove({});

#$rename

db.Books.insert([
{"nmae":"斗罗大陆","price":99.8},
{"nmae":"斗罗大陆·绝世唐门","price":99.8},
{"nmae":"斗破苍穹","price":99.8}]);
db.Books.find();

db.Books.updateMany({},{$rename:{"nmae":"name"}});
db.Books.find();

db.Books.remove({});

#$set

db.Books.insert([
{"name":"斗罗大陆"},
{"name":"斗罗大陆·绝世唐门"},
{"name":"斗破苍穹"}]);
db.Books.find();

db.Books.updateMany({"name":"斗罗大陆"},{$set:{"price":99.8}});
db.Books.find();

db.Books.updateMany({"name":"斗罗大陆"},{$set:{"recordCount":1}});
db.Books.find();

db.Books.remove({});

#$setOnInsert

db.Books.insert([{"name":"斗罗大陆"}]);
db.Books.find();

db.Books.update({"name":"斗罗大陆"},{$setOnInsert:{"price":99.8}});
db.Books.find();

db.Books.update({"name":"斗罗大陆·绝世唐门"},{$setOnInsert:{"price":99.8}},{upsert:true});
db.Books.find();

db.Books.remove({});

#$unset

db.Books.insert([{"name":"草稿"}]);
db.Books.find();

db.Books.update({"name":"草稿"},{$unset:{"name":""}});
db.Books.find();

db.Books.remove({});