• mongodb之常用命令


    help show help
    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
    use <db name> set curent database to <db name>
    db.addUser (username, password)
    db.removeUser(username)
    db.cloneDatabase(fromhost)
    db.copyDatabase(fromdb, todb, fromhost)
    db.createCollection(name, { size : ..., capped : ..., max : ... } )
    db.getName()
    db.dropDatabase()
    // runs the collstats] command on each collection in the database
    db.printCollectionStats()
    db.currentOp() displays the current operation in the db
    db.killOp() kills the current operation in the db
    db.getProfilingLevel()
    db.setProfilingLevel(level) 0=off 1=slow 2=all
    db.getReplicationInfo()
    db.printReplicationInfo()
    db.printSlaveReplicationInfo()
    db.repairDatabase()
    db.version() current version of the server
    db.shutdownServer()
    ======ddl
    db.foo.drop() drop the collection
    db.foo.dropIndex(name)
    db.foo.dropIndexes()
    db.foo.getIndexes()
    db.foo.ensureIndex(keypattern,options) - options object has these possible
    fields: name, unique, dropDups
    db.foo.find( [query] , [fields]) - first parameter is an optional
    query filter. second parameter
    is optional
    set of fields to
    return
    .
    e.g. db.foo.find(
    { x : 77 } ,
    { name : 1 , x : 1 } )
    db.foo.find(...).count()
    db.foo.find(...).limit(n)
    db.foo.find(...).skip(n)
    db.foo.find(...).sort(...)
    db.foo.findOne([query])
    db.foo.getDB() get DB object associated with collection
    db.foo.count()
    db.foo.group( { key : ..., initial: ..., reduce : ...[, cond: ...] } )
    db.foo.renameCollection( newName ) renames the collection
    db.foo.stats()
    db.foo.dataSize()
    db.foo.storageSize() - includes free space allocated to
    this
    collection
    db.foo.totalIndexSize() - size in bytes of all the indexes
    db.foo.totalSize() - storage allocated
    for
    all data and indexes
    db.foo.validate() (slow)
    db.foo.insert(obj)
    db.foo.update(query, object[, upsert_bool])
    db.foo.save(obj)
    db.foo.remove(query) - remove objects matching query
    remove({}) will remove all
  • 相关阅读:
    mysql事务
    mysql函数
    mysql自连接
    MYSQL添加外键关联
    SQL多表查询
    SQL数据完整性
    SQL limit
    SQL分组查询
    升级GCC 6.2编译LLVM的问题
    Quartz时SLF4J错误
  • 原文地址:https://www.cnblogs.com/imap/p/2791541.html
Copyright © 2020-2023  润新知