node.js连接mongodb数据库之总结三

mongodb安装好以后，有时候需要在终端进行一些操作。这里特此总结一些常用操作。

查看所有数据库：show dbs;

> show dbs
admin   0.000GB
config  0.000GB
local   0.000GB
shop    0.000GB

选择数据库：use shop;

> use shop
switched to db shop

查看数据库：db.stats();

> db.stats();
{
    "db" : "shop",
    "collections" : 3,
    "views" : 0,
    "objects" : 8,
    "avgObjSize" : 103,
    "dataSize" : 824,
    "storageSize" : 90112,
    "numExtents" : 0,
    "indexes" : 4,
    "indexSize" : 106496,
    "fsUsedSize" : 102170722304,
    "fsTotalSize" : 121123069952,
    "ok" : 1
}

查看当前数据库有那些表：show collections

> show collections;
ids
shop
users

查看表状态：db.shop.stats(); // shop为表名

> db.shop.stats(); 
{
  "ns" : "shop.shop",
  "size" : 37,
  "count" : 1,
  "avgObjSize" : 37,
  "storageSize" : 16384,
  "capped" : false,
  "wiredTiger" : {...}//太长就不显示了
    ...
}

查看表内容：db.users.find();// users为表名

"_id" : ObjectId("5bbdb40e73efc4194566703d"), "id" : 1, "name" : "文天祥", "age" : 27, "password" : "ddd99980", "create_time" : "2018-10-10 16:10", "__v" : 0 }
{ "_id" : ObjectId("5bbdb42973efc4194566703e"), "id" : 2, "name" : "文天祥", "age" : 27, "password" : "ddd99980", "create_time" : "2018-10-10 16:11", "__v" : 0 }
{ "_id" : ObjectId("5bbdb42c73efc4194566703f"), "id" : 3, "name" : "文天祥", "age" : 27, "password" : "ddd99980", "create_time" : "2018-10-10 16:11", "__v" : 0 }
{ "_id" : ObjectId("5bbdc5e79384b81dc131756c"), "id" : 5, "name" : "林小青", "age" : 27, "password" : "ddd99980", "create_time" : "2018-10-10 17:27", "__v" : 0 }
{ "_id" : ObjectId("5bbdc6a0b0123b1e539beb01"), "password" : "888999", "id" : 6, "name" : "林小青", "age" : 27, "create_time" : "2018-10-10 17:30", "__v" : 0 }
{ "_id" : ObjectId("5bbdc6abb0123b1e539beb02"), "password" : "888999", "id" : 7, "name" : "林红", "age" : 27, "create_time" : "2018-10-10 17:30", "__v" : 0 }

清空表：db.users.remove({});// users为表名

db.users.remove({});
WriteResult({ "nRemoved" : 6 })