Shulou(Shulou.com)05/31 Report--

This article focuses on "what is a non-relational database MongoDB", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "what is a non-relational database MongoDB"!

Preface

Mongodb, a distributed document storage database, written in C++ language, is designed to provide scalable and high-performance data storage solutions for WEB applications. MongoDB is a high-performance, open source, schemalless document database, which is one of the most popular NoSql databases. It can be used to replace the traditional relational database or key / value storage in many scenarios. Let's talk about its specific usage.

First, installation configuration 1. download

Download address is as follows:

Https://590m.com/file/7715018-442253530

Then click the msi installation file to install, because it is relatively large, it is recommended not to install on disk C, select the options in the following figure.

Here I choose E:\ mongodb. Following the steps, it is relatively simple on the whole. The only thing to note is that there is an option that cannot be checked, as shown below:

two。 Configuration file

Create an E:\ mongodb\ data\ log directory to store log files

Create a new mongodb.log in the E:\ mongodb\ data\ log directory to store log information

Create an E:\ mongodb\ data\ db directory to store database data

Create a mongo.config in the E:\ mongodb directory and copy the following text inside the file:

# data file here = correspond to the directory where the data is stored dbpath=E:\ mongodb\ data\ db # log file here = after the corresponding path to the log file logpath=E:\ mongodb\ data\ log\ mongodb.log # error log is appended. After configuring this option, the log of mongodb will be appended to the existing log file instead of creating a new file logappend=true # enable log file Journal=true # is enabled by default to filter out some useless log information. If you need to debug, set the port number to false quiet=true # and default to 27017 port=270173. Configure environment variables

4. Create a location for database files

Enter the command prompt and type the following command:

Mongod.exe-- dbpath E:\ mongodb\ data\ db

-- dbpath is the location where the database files are created, and mongo needs to confirm the location of this directory.

5. Verify normal access

We enter the following website in the browser:

Http://localhost:27017/

As shown in the figure:

If the browser returns such a string in English, it means that the mongodb database has been started successfully.

But every time it is too troublesome to start, we can add it to the system task and let it boot itself.

6. Installation log file and service name C:\ Users\ Administrator > mongod.exe-- dbpath E:\ mongodb\ data\ db-logpath E:\ mongodb\ data\ log\ mongodb.log-install-serviceName "MongoDB"

If it shows that it already exists, as shown in the figure:

Then, delete the service first:

Sc delete MongoDB

Just enter the last command again.

7. Start mongodb

And then we start it up:

Net start MongoDB

You can see that the startup is successful, it is not easy.

Shut down the mongodb service:

Net stop MongoDB II, mongodb database addition, deletion, modification and query

As we all know, mongodb does not have the concept of tables, and storage is done by collections, so what we need to create is collections.

Let's first take a look at the most common database operations in mongodb. First, open a command prompt and enter the following command to enter the environment:

/ / create database use data / / Show all databases show dbs show databases / / View the current database db db.getName () / / delete the current database db.dropDatabase () / / repair the current database db.repairDatabase () / / copy the specified database data from the specified machine to a database db.copyDatabase ("my_db", "you_db" "127.0.0.1") / / Clone the database db.cloneDatabase ("127.0.0.1") from the specified host / / create a collection with a fixed collection size of 100Max value 1000 db.createCollection ('student', {capped:true,size:100) Max:1000}) / / Show all collections show collections / / get all aggregations of the current db db.getCollectionNames () / display the status of all clustered indexes of the current db db.printCollectionStats () / / delete the collection db.hw.drop () / / get the specified name of the clustered collection db.getCollection ("hw") / / insert the collection _ id if there is an error db.hw.insert ({_ id:0001,'name':'hw') 'age':10}) / / display collection content db.hw.find () / / display a collection content db.hw.findOne () / / format display collection content db.hw.find (). Pretty () / / Update db.hw.save ({_ id:0001,'name':'hw') when saving collection _ id exists 'age':10}) / / Update collection $set specified key and update does not exist, create $unset delete db.hw.update ({' name':'hw'}, {'name':'xz'}) / / update a data replacement db.hw.update ({' name':'hw'}, {$set {'name':'xz'}}) / / update a data update db.hw.update ({' name':'hw'}) {'name':'xz'}, {multi:true}) / / Update all data / / Delete collection data db.hw.remove ({' name':'hw'}, {justOne:true}) / / delete a piece of data db.hw.remove ({'name':'hw'}, {justOne:false}) / / delete all data / / set rename db.user.renameCollection ("hw") Rename user to hw / / query data $lt-- less than $lte-- less than $gt-- greater than $gte-- greater than $ne-- not equal to $in $nin-- is in the range $and $or query condition and or $type / ^ abc/ $regex:'abc$' regular expression limit (num) displays a specified number of results skip (num) skips a specified number of results $where query function _ id default display If it is not displayed, set the value to 0 sort () to sort If the parameter is 1 ascending order-1 descending order count () to count the number of query results, you can also put the query parameters into count distinct () deduplicated db.hw.find ({age: {$gte:18}}) db.hw.find ({age: {$in: [12rem 32m 21]}}) db.hw.find ({$and: {age: {$in: [12jue 32m 21]}) {age: {$gte:18}) db.hw.find ({age: {$gte:18}}) .skip (3) .limit (2) db.hw.find ({age:/ ^ ABC /, name: {$regex:'123 $'}}) db.hw.find ($where:function () {return this.age=, value db.collection.find ({"field": {$lt: value}}) / / less than: field

= value db.collection.find ({"field": {$lte: value}) / less than or equal to: field db.test.find (). Skip (5) .limit (5). Count () 9 > db.test.find () .skip (5) .limit (5) .count (true) 4

8. User Action / / add a user db.addUser ("hw") db.addUser ("hw", "123321", true) # add user, set password, whether read-only / database authentication, security mode db.auth ("hw") "123123") / / display all current users show users / / delete user db.removeUser ("hw") 9. Other commands / / query the available storage space of the collection of the specified database db.hw.storageSize () / query the set of allocated storage space db.hw.totalSize () / check the status of the database server db.serverStatus () / query the statistical information of the specified database db.stats () / current db version db.version () / view the linked machine address of the current db db.getMongo () 10. Visualization tools to improve interaction

In order to make our operations more user-friendly and more intuitive to display operational data, we can use a visualization tool. What I bring to you today is Navicat-mongo, which is a database visualization tool in the Navicat family that only operates on mongo databases. Download address:

Https://590m.com/file/7715018-442253555

Software reason to crack the program, as long as a simple operation can be cracked.

After downloading, follow the prompts to install it.

In this way, we can basically complete the operation of the database, and then it is time for everyone to knock according to the command.

At this point, I believe you have a deeper understanding of "what is a non-relational database MongoDB". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.