1、创建数据库
--创建数据库school
use school_che;
-- 查看所有数据库
show dbs;
-- 插入数据
db.school_che.insert({"name":"小明"});
– 创建名称为t_role的集合,并且插入数据
db.t_role.insert({"name":"小明"});
db.t_role.save({"name":"小明"});
2、删除数据库
use school_che;
--删除数据库
db.dropDatabase();
3、创建集合
use school_che;
-- 创建名称为t_user的集合
db.createCollection("t_user");
4、删除集合
--删除名称为school_cheche的集合
db.school_cheche.drop();
5、展示所有集合
use school_cheche;
show collections;
6、插入数据(文档)
-- 其一
db.getCollection("t_user").insertMany([
{
"areaIds" : [440300],
"insuranceCompanyIds" : [2005,2011],
"suitePackageIds" : [18],
"manufacturerIds" : [92],
"username" : "小明"
},
{
"areaIds" : [440300],
"insuranceCompanyIds" : [2005,2011],
"suitePackageIds" : [19],
"manufacturerIds" : [92],
"username" : "小红"
},
{
"areaIds" : [440300],
"insuranceCompanyIds" : [2005,2011],
"suitePackageIds" : [20],
"manufacturerIds" : [92],
"username" : "小黄"
},
]);
-- 其二
db.t_user.insertMany([
{
"areaIds" : [440300],
"insuranceCompanyIds" : [2005,2011],
"suitePackageIds" : [18],
"manufacturerIds" : [92],
"username" : "小花"
},
{
"areaIds" : [440300],
"insuranceCompanyIds" : [2005,2011],
"suitePackageIds" : [19],
"manufacturerIds" : [92],
"username" : "小李 "
}
]);
-- 其三
db.t_user.insertOne({
"areaIds" : [440300],
"insuranceCompanyIds" : [2005,2011],
"suitePackageIds" : [18],
"manufacturerIds" : [92],
"username" : "哈哈1"
});
-- 其四
db.getCollection("t_user").insertOne({
"areaIds" : [440300],
"insuranceCompanyIds" : [2005,2011],
"suitePackageIds" : [18],
"manufacturerIds" : [92],
"username" : "哈哈2"
});
7、更新数据
– 更新多条满足条件的数据
db.t_user.updateOne({username:'zhangsan'},{$set:{age:25}},false,true);
db.getCollection('edi_config').update(
{insuranceCompany: NumberLong('1111'), env : "test"},
{$set:{
"config.publicKey": "aaaa",
"config.wapPayUrl":"aaaa",
"config.payUrl":"aaaa"
}
}
);
8、查询数据
db.getCollection("t_user").find({username:"小明"}).count();
db.getCollection("t_user").find({username:/小/});
db.getCollection("t_user").find({username:/^小/});
db.getCollection("t_user").find({username:/小^/});
db.getCollection("t_user").find({username:{$regex:"小"}});
db.getCollection("t_user").find({manufacturerIds:[92]}).sort({suitePackageIds:-1});
db.getCollection("t_user").find({manufacturerIds:[92]}).sort({suitePackageIds:1});
db.getCollection("t_user").find({manufacturerIds:[92]}).skip(1).limit(2);
db.getCollection("t_user").find({username:"小明"}, {id:true, username:true});
9、创建索引
#说明:1表示升序,-1表示降序。
db.t_user.createIndex({'username':1});
db.t_user.createIndex({'class':-1});
db.getCollection('ar_a_record').ensureIndex({"aaId":1},{"name":"index_aaId"});
db.getCollection('ar_a_record').ensureIndex({"aaId":1},{"name":"index_aaId"});
/*唯一索引*/
db.getCollection('aa_aaaa_record').ensureIndex({"aaaId":1},{"unique":true});
/*查看索引*/
db.t_user.getIndexes()
/*删除索引根据名称*/
db.t_user.dropIndex("index_aaaaId");
/*删除所有索引*/
db.t_user.dropIndex();