mongodb命令行操作

正西發表於 2020-1-9 13:38:00

查看mongo命令帮助
<div class="cnblogs_code">
<pre>sitewhere-mongodb-primary-0:/$ mongo --help
MongoDB shell version v4.0.3
usage: mongo [file names (ending in .js)]
db address can be:
foo foo database on local machine
192.168.0.5/foo foo database on 192.168.0.5 machine
192.168.0.5:9999/foofoo database on 192.168.0.5 machine on port 9999
Options:
--shell run the shell after executing files
--nodb don't connect to mongod on startup - no 
 'db address' arg expected
--norc will not run the ".mongorc.js" file on
 start up
--quiet be less chatty
--port arg port to connect to
--host arg server to connect to
--eval arg evaluate javascript
-h [ --help ] show this usage information
--version show version information
--verbose increase verbosity
--ipv6 enable IPv6 support (disabled by default)
--disableJavaScriptJIT disable the Javascript Just In Time
 compiler
--enableJavaScriptJIT enable the Javascript Just In Time
 compiler
--disableJavaScriptProtection allow automatic JavaScript function
 marshalling
--ssl use SSL for all connections
--sslCAFile arg Certificate Authority file for SSL
--sslPEMKeyFile arg PEM certificate/key file for SSL
--sslPEMKeyPassword arg password for key in PEM file for SSL
--sslCRLFile arg Certificate Revocation List file for SSL
--sslAllowInvalidHostnames allow connections to servers with
 non-matching hostnames
--sslAllowInvalidCertificates allow connections to servers with invalid
 certificates
--sslFIPSMode activate FIPS 140-2 mode at startup
--sslDisabledProtocols arg Comma separated list of TLS protocols to
 disable
--retryWrites automatically retry write operations upon
 transient network errors
--disableImplicitSessions do not automatically create and use
 implicit sessions
--jsHeapLimitMB arg set the js scope's heap size limit

Authentication Options:
-u [ --username ] arg username for authentication
-p [ --password ] arg password for authentication
--authenticationDatabase arg user source (defaults to dbname)
--authenticationMechanism arg authentication mechanism
--gssapiServiceName arg (=mongodb)Service name to use when authenticating
 using GSSAPI/Kerberos
--gssapiHostName arg Remote host name to use for purpose of
 GSSAPI/Kerberos authentication</pre>
</div>
 
连接数据库
<div class="cnblogs_code">
<pre>sitewhere-mongodb-primary-0:/$ mongo -u username -p password
MongoDB shell version v4.0.3</pre>
</div>
 
查看帮助
<div class="cnblogs_code">
<pre>rs0:PRIMARY> help
db.help() help on db methods
db.mycoll.help() help on collection methods
sh.help() sharding helpers
rs.help() replica set helpers
help admin administrative help
help connect connecting to a db help
help keys key shortcuts
help misc misc things to know
help mr mapreduce

show dbs show database names
show collections show collections in current database
show users show users in current database
show profile show most recent system.profile entries with time >= 1ms
show logs show the accessible logger names
show log prints out the last segment of log in memory, 'global' is default
use <db_name> set current database
db.foo.find() list objects in collection foo
db.foo.find( { a : 1 } ) list objects in foo where a == 1
it result of the last line evaluated; use to further iterate
DBQuery.shellBatchSize = x set default number of items to display on shell
exit quit the mongo shell</pre>
</div>
 
查看库
<div class="cnblogs_code">
<pre>rs0:PRIMARY> show dbs;
admin 0.000GB
config 0.000GB
local 0.001GB
tenant-default0.000GB</pre>
</div>
 
创建/切换数据库： use dancy ， dancy是数据库名称 如果use后面的数据库存在则切换到该数据库，如果不存在则创建。
<div class="cnblogs_code">
<pre>rs0:PRIMARY> use tenant-default;
switched to db tenant-default</pre>
</div>
 
查看当前所在数据库
<div class="cnblogs_code">
<pre>rs0:PRIMARY> db
tenant-default</pre>
</div>
 
查看当前库有多少个集合
<div class="cnblogs_code">
<pre>rs0:PRIMARY> show collections
assets
assettypes
devicestates
events
scheduledjobs
schedules</pre>
</div>
 
查询某个集合的内容
<div class="cnblogs_code">
<pre>rs0:PRIMARY> db.assets.find()
{ "_id" : BinData(3,"YE2/smBotc1ZqEhMNcL2nA=="), "atid" : BinData(3,"FkP4uECSQu3w2PBgMGlfsA=="), "name" : "Derek Adams", "imgu" : "https://s3.amazonaws.com/sitewhere-demo/people/derek.jpg", "icon" : null, "bgco" : null, "fgco" : null, "bdco" : null, "tokn" : "derek.adams@sitewhere.com", "crdt" : ISODate("2020-01-07T09:02:54.510Z"), "meta" : { "role" : "dev", "phone" : "678-555-1212", "username" : "derek" } }
{ "_id" : BinData(3,"J0LV83h9RGGwjZDWnRwdrw=="), "atid" : BinData(3,"FkP4uECSQu3w2PBgMGlfsA=="), "name" : "Bryan Rank", "imgu" : "https://s3.amazonaws.com/sitewhere-demo/people/bryan.jpg", "icon" : null, "bgco" : null, "fgco" : null, "bdco" : null, "tokn" : "bryan.rank@sitewhere.com", "crdt" : ISODate("2020-01-07T09:02:54.518Z"), "meta" : { "role" : "sales", "phone" : "770-555-1212", "username" : "bryan" } }
{ "_id" : BinData(3,"601iYuo9PWETKfQgGVwXtw=="), "atid" : BinData(3,"FkP4uECSQu3w2PBgMGlfsA=="), "name" : "Martin Weber", "imgu" : "https://s3.amazonaws.com/sitewhere-demo/people/martin.jpg", "icon" : null, "bgco" : null, "fgco" : null, "bdco" : null, "tokn" : "martin.weber@sitewhere.com", "crdt" : ISODate("2020-01-07T09:02:54.520Z"), "meta" : { "role" : "busdev", "phone" : "404-555-1212", "username" : "martin" } }</pre>
</div>
 
db用法 db.2个Tab键
<div class="cnblogs_code">
<pre>rs0:PRIMARY> db.
db.adminCommand( db.dbEval( db.getFreeMonitoringStatus( db.getSiblingDB( db.isMaster( db.revokePrivilegesFromRole( db.stats(
db.aggregate( db.disableFreeMonitoring( db.getLastError( db.getSisterDB( db.killOP( db.revokeRolesFromRole( db.toLocaleString
db.auth( db.dropAllRoles( db.getLastErrorCmd( db.getSlaveOk( db.killOp( db.revokeRolesFromUser( db.toString(
db.changeUserPassword( db.dropAllUsers( db.getLastErrorObj( db.getUser( db.listCommands( db.runCommand( db.tojson(
db.cloneCollection( db.dropDatabase( db.getLogComponents( db.getUsers( db.loadServerScripts( db.runCommandWithMetadata( db.unsetWriteConcern(
db.cloneDatabase( db.dropRole( db.getMongo( db.getWriteConcern( db.logout( db.runReadCommand( db.updateRole(
db.commandHelp( db.dropUser( db.getName( db.grantPrivilegesToRole( db.printCollectionStats( db.serverBits( db.updateUser(
db.constructor db.enableFreeMonitoring( db.getPrevError( db.grantRolesToRole( db.printReplicationInfo( db.serverBuildInfo( db.valueOf
db.copyDatabase( db.eval( db.getProfilingLevel( db.grantRolesToUser( db.printShardingStatus( db.serverCmdLineOpts( db.version(
db.createCollection( db.forceError( db.getProfilingStatus( db.group( db.printSlaveReplicationInfo(db.serverStatus(
db.createRole( db.fsyncLock( db.getQueryOptions( db.groupcmd( db.propertyIsEnumerable db.setLogLevel(
db.createUser( db.fsyncUnlock( db.getReplicationInfo( db.groupeval( db.prototype db.setProfilingLevel(
db.createView( db.getCollection( db.getRole( db.hasOwnProperty db.removeUser( db.setSlaveOk(
db.currentOP( db.getCollectionInfos( db.getRoles( db.help( db.repairDatabase( db.setWriteConcern(
db.currentOp( db.getCollectionNames( db.getSession( db.hostInfo( db.resetError( db.shutdownServer(</pre>
</div>
 
创建数据库
<div class="cnblogs_code">
<pre>rs0:PRIMARY> use dancy
switched to db dancy</pre>
</div>
 
 往里面插入数据show dbs才能显示到
<div class="cnblogs_code">
<pre>rs0:PRIMARY> db.jihe.insert({"name": "lin"})
WriteResult({ "nInserted" : 1 })
rs0:PRIMARY> show dbs
admin 0.000GB
config 0.000GB
dancy 0.000GB
local 0.001GB
tenant-default0.000GB
rs0:PRIMARY> show collections
jihe
rs0:PRIMARY> db.jihe.find()
{ "_id" : ObjectId("5e16b3a7ab5fc9b3b213226b"), "name" : "lin" }</pre>
</div>
 
 删除集合
<div class="cnblogs_code">
<pre>rs0:PRIMARY> db.jihe.drop()
true</pre>
</div>
 
插入文档,user是集合名称
<div class="cnblogs_code">
<pre>rs0:PRIMARY> db.user.insert({"name": "lin", "age": 23})
WriteResult({ "nInserted" : 1 })
rs0:PRIMARY> show collections
jihe
user</pre>
</div>
 
删除当前所在数据库
<div class="cnblogs_code">
<pre>rs0:PRIMARY> db.dropDatabase()
{
"dropped" : "dancy",
"ok" : 1,
"operationTime" : Timestamp(1578546278, 2),
"$clusterTime" : {
 "clusterTime" : Timestamp(1578546278, 2),
 "signature" : {
 "hash" : BinData(0,"AAAAAAAAAAAAAAAAAAAAAAAAAAA="),
 "keyId" : NumberLong(0)
 }
}
}
rs0:PRIMARY> show dbs;
admin 0.000GB
config 0.000GB
local 0.001GB
tenant-default0.000GB</pre>
</div> 
来源：https://www.cnblogs.com/linyouyi/p/12171017.html

頁: [1]

琼殿技术论坛's Archiver

mongodb命令行操作