mongodb入门命令-创建表数据(二)

心平气和过日子 發表於 2019-9-7 11:54:00

1.mongodb入门命令
1.1 show databases; 或 show dbs; //查看当前的数据库
<div class="cnblogs_code">
<pre>> show dbs;
admin 0.000GB
config0.000GB
local 0.000GB</pre>
</div>
1.2 use databaseName  选择库
      show tables/collections 查看当前库下的collections
1.3 如何创建库
　　mongodb 的库是隐式创建，你可以use一个不存在的库
　　然后在该库下创建collection，即可创建库
1.4 db.createCollection('collectionName');  //创建collection
1.5 collection 允许隐式创建
　  db.collectionName.insert(document);
1.6 db.collectionName.drop();       /删除collection
<div class="cnblogs_code">
<pre>> use shop
switched to db shop
> db.createCollection('user');
{ "ok" : 1 }
> show dbs;
admin 0.000GB
config0.000GB
local 0.000GB
shop 0.000GB
> show collections;
user</pre>
</div>
1.7插入user表语句
(1)自动生成id值
<div class="cnblogs_code">
<pre> db.user.insert({name:'lisi',age:22})
WriteResult({ "nInserted" : 1 })
> db.user.find();
{ "_id" : ObjectId("5d73077c71b815674de4d152"), "name" : "lisi", "age" : 22 }</pre>
</div>
(2) 指定生成id
<div class="cnblogs_code">
<pre>> db.user.insert({_id:2,name:'wangwu',age:25})
WriteResult({ "nInserted" : 1 })
> db.user.find();
{ "_id" : ObjectId("5d73077c71b815674de4d152"), "name" : "lisi", "age" : 22 }
{ "_id" : 2, "name" : "wangwu", "age" : 25 }</pre>
</div>
(3) 插入多层
<div class="cnblogs_code">
<pre>> db.user.insert({_id:3,name:'xiaobing',hobby:['basketball','football'],intro:{'title':'My intro','content':'from china'}});
WriteResult({ "nInserted" : 1 })
> db.user.find();
{ "_id" : ObjectId("5d73077c71b815674de4d152"), "name" : "lisi", "age" : 22 }
{ "_id" : 2, "name" : "wangwu", "age" : 25 }
{ "_id" : 3, "name" : "xiaobing", "hobby" : [ "basketball", "football" ], "intro" : { "title" : "My intro", "content" : "from china" } }
></pre>
</div>
 1.8 其实mongodb不需要声明表,可直接写入表数据,即可创建成功!
<div class="cnblogs_code">
<pre>> show tables;
user
> db.goods.insert({_id:1,name:'oppoR11',price:'3000'});
WriteResult({ "nInserted" : 1 })
> show tables;
goods
user
> db.goods.find()
{ "_id" : 1, "name" : "oppoR11", "price" : "3000" }</pre>
</div>
1.9 删除表 db.collectionName.drop();
<div class="cnblogs_code">
<pre>> show collections
goods
user
> db.goods.drop();
true
> show collections;
user
> </pre>
</div>
2.0 删除数据库
<pre> db.dropDatabase()</pre>
<div class="cnblogs_code">
<pre>> show dbs;
admin 0.000GB
config0.000GB
local 0.000GB
shop 0.000GB
> use shop;
switched to db shop

> db.dropDatabase();
{ "dropped" : "shop", "ok" : 1 }
> show dbs;
admin 0.000GB
config0.000GB
local 0.000GB
> </pre>
</div>
2.1 查询帮助 db.help();
<div class="cnblogs_code">
<pre>> db.help()
DB methods:
 db.adminCommand(nameOrDocument) - switches to 'admin' db, and runs command [just calls db.runCommand(...)]
 db.aggregate([pipeline], {options}) - performs a collectionless aggregation on this database; returns a cursor
 db.auth(username, password)
 db.cloneDatabase(fromhost) - deprecated
 db.commandHelp(name) returns the help for the command
 db.copyDatabase(fromdb, todb, fromhost) - deprecated
 db.createCollection(name, {size: ..., capped: ..., max: ...})
 db.createView(name, viewOn, [{$operator: {...}}, ...], {viewOptions})
 db.createUser(userDocument)
 db.currentOp() displays currently executing operations in the db
 db.dropDatabase()
 db.eval() - deprecated
 db.fsyncLock() flush data to disk and lock server for backups
 db.fsyncUnlock() unlocks server following a db.fsyncLock()
 db.getCollection(cname) same as db['cname'] or db.cname
 db.getCollectionInfos([filter]) - returns a list that contains the names and options of the db's collections
 db.getCollectionNames()
 db.getLastError() - just returns the err msg string
 db.getLastErrorObj() - return full status object
 db.getLogComponents()
 db.getMongo() get the server connection object
 db.getMongo().setSlaveOk() allow queries on a replication slave server
 db.getName()
 db.getPrevError()
 db.getProfilingLevel() - deprecated
 db.getProfilingStatus() - returns if profiling is on and slow threshold
 db.getReplicationInfo()
 db.getSiblingDB(name) get the db at the same server as this one
 db.getWriteConcern() - returns the write concern used for any operations on this db, inherited from server object if set
 db.hostInfo() get details about the server's host
 db.isMaster() check replica primary status
 db.killOp(opid) kills the current operation in the db
 db.listCommands() lists all the db commands
 db.loadServerScripts() loads all the scripts in db.system.js
 db.logout()
 db.printCollectionStats()
 db.printReplicationInfo()
 db.printShardingStatus()
 db.printSlaveReplicationInfo()
 db.dropUser(username)
 db.repairDatabase()
 db.resetError()
 db.runCommand(cmdObj) run a database command.if cmdObj is a string, turns it into {cmdObj: 1}
 db.serverStatus()
 db.setLogLevel(level,<component>)
 db.setProfilingLevel(level,slowms) 0=off 1=slow 2=all
 db.setWriteConcern(<write concern doc>) - sets the write concern for writes to the db
 db.unsetWriteConcern(<write concern doc>) - unsets the write concern for writes to the db
 db.setVerboseShell(flag) display extra information in shell output
 db.shutdownServer()
 db.stats()
 db.version() current version of the server</pre>
</div>
未完,后续补充....
  
来源：https://www.cnblogs.com/xiaozhaoboke/p/11479313.html

頁: [1]

琼殿技术论坛's Archiver

mongodb入门命令-创建表数据(二)