mongodb terminal commands

Label:Learn a little bit every day, progress a little, record a little, share a little, summarize a little. First, the basic application 1. Common commands Show DBS Display Database list Use dbname into the dbname database, case sensitive, no this database does not matter Show Collections displays a collection in the database, equivalent to a table 2. Create and add Db.users.save ({"Name": "LECAF"}) created a collection named users and added a new {"N

Label:MongoDB Common commands: Talk about a special situation, if the admin uses encryption, then you create a database must be encrypted to use, this is the problem I personally met. Enter the MongoDB command line, note: The default entry is the test library $mongo//admin is the core group of database management, the total permissions console, stored the user name password role and other information. Cre

] ', ' Al ': [' [email protected] ', ' [email protected] ']}) #根据query条件修改, insert if not present, allow multiple records to be modified Db.foo.update ({' yy ': 5},{' $set ': {' xx ': 2}},upsert=true,multi=true) Records of #删除yy =5 Db.foo.remove ({' yy ': 5}) #删除所有的记录 Db.foo.remove () index #增加索引: 1 (Ascending), -1 (Descending) Db.things.ensureIndex ({firstname:1, lastname:1}, {unique:true}); #索引子对象 Db.user_addr.e

TableName where key01=valu01 and key02=valu02Not equal to Operation: Db.collections.find ({key01:{$ne: valu01}}); SELECT * from TableName where key01 $not Related actions: Db.collections.find ({key:{$not: {$in: [valu01,valu02]}}}); SELECT * from TableName where key not in (VALU01,VALU02)Note: Db.collections.find (key:{$not: valu01}); No such wording.Regular Expressions: Follow-up studiesRelated Operations for arrays$mod: Modulo function$inc$maxscan: Make the maximum number of scanned documents

Tags: mongodbMONGO official website Http://www.mongodb.org/downloadsVue Tools Download http://www.mongovue.com/downloads/Build a folder, put the extracted MONGO file, in the new one put the specified databaseMake a variable, specify binThe following folders and paths can be customizedMongod--dbpath D:\installSoft\mongoDbDATAMONGO 127.0.0.1:27017/adminHere is a simple commandDownload MongoDB specified path datamongod--dbpath e:\

does not replace the original data, so the correct way to update it is as follows:Db.unicorns.update ({name: ' Jingdong '}, {$set: {weight:590}})Db.unicorns.update ({name: ' Pilot '}, {$inc: {If there is an update, add db.hits.update ({page: ' Unicorns '}, {$inc: {hits:1}}, True);d b.hits.find (), or True (upset) using the third parameter setting, default is False#批量更新db. Unicorns.update ({}, {$set: {vaccinated:true}});d B.unicorns.find ({vaccinated:true}); All data will not be vaccinated is up

5. More commands DB. adduser (username, password) Add User DB. Auth (usrename, password) sets database connection Verification DB. clonedatabase (fromhost) clone a database from the target serverDB. commandhelp (name) returns the help for the commandDB. copydatabase (fromdb, todb, fromhost) copy the database fromdb --- source database name, todb --- target database name, fromhost --- source database server addressDB. createcollection (name, {size: 333

Db.createcollection ("tablename")//CREATE TABLE Use Password to access Use admin Db.adduser ("admin", "admin")//here must set the password, otherwise the test database settings password is not valid Db.auth ("admin", "admin") Use test Db.adduser ("Test", "test") ============================= Other Commands ================================ Db. AddUser (username,password) Add user Db.auth (Usrename,password) Set up database connection verif

Label:1. Add the user to the TD database using use TD and then execute Db.adduser ("name", "password"); can be added;2. Enable users to use Db.auth ("name", "password");3. Generally in the project we want to enable security checks, in the configuration of the MongoDB database path at the time after adding--auth so that the security check is started, not the database user is not able to operate the database;4. Delete a user using Db.system.users.remove

Label:The MongoDB shell is more than just an interactive shell, it also supports execution of specified JavaScript files, and also supports execution of specified command fragments. With this feature, MongoDB can be combined with the Linux shell to do most of the daily management and maintenance work.executes the specified commandFor example, there are several common ways to query the number of records in t

}). ForEach (Printjson);Db.users.find ({age: {$lte: +}}, {age:true}). ForEach (Printjson);Exclude The Age columnDb.users.find ({age: {$lte: +}}, {Age:false}). ForEach (Printjson); 9. The Foreach transfer function displays informationDb.things.find ({x:4}). ForEach (function (x) {print (Tojson (x));}); Some of the commands that you might use: $ne: Not equal to$GT: Greater Than$LT: Less than$gte: greater than or equal to$lte: Less than or equal to Curr