Home Database MongoDB Show database in MongoDB

Show database in MongoDB

Aug 26, 2023 pm 08:45 PM

Show database in MongoDB

To display the number of databases in MongoDB, you need to create at least one document in the database.

Suppose you have created a database but have not added any documents to it. Then that particular database will not be visible in the database list.

The following is the query to create the database -

> use app;
switched to db app
Copy after login

The following is the query to display all databases -

> show dbs;
Copy after login
Copy after login

This will produce the following output. The new database "app" will not be visible because we have not added at least one document in it -

admin                0.002GB
business             0.000GB
config               0.000GB
local                0.000GB
main                 0.000GB
my                   0.001GB
sample               0.003GB
sampleDemo         0.000GB
studentSearch 0.000GB
test 0.022GB
university 0.000GB
web 0.001GB
webcustomertracker 0.000GB
Copy after login

Let's first create a collection containing the documents in the "app" database -

> db.demo.insert({"StudentName":"Chris"});
WriteResult({ "nInserted" : 1 })
Copy after login

The following is the query to display all the documents in the collection with the help of find() method-

> db.demo.find();
Copy after login

This will produce the following output-

{ "_id" : ObjectId("5e07250e25ddae1f53b62204"), "StudentName" : "Chris" }
Copy after login

This is the query to display all the databases in MongoDB-

> show dbs;
Copy after login
Copy after login

This will produce the following output. Now the "app" database will be visible in the database list -

admin                      0.002GB
app                        0.000GB
business                   0.000GB
config                     0.000GB
local                      0.000GB
main                       0.000GB
my                         0.001GB
sample                     0.003GB
sampleDemo                 0.000GB
studentSearch            0.000GB
test 0.022GB
university 0.000GB
web 0.001GB
webcustomertracker 0.000GB
Copy after login

The above is the detailed content of Show database in MongoDB. For more information, please follow other related articles on the PHP Chinese website!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

MongoDB Performance Tuning: Optimizing Read & Write Operations MongoDB Performance Tuning: Optimizing Read & Write Operations Apr 03, 2025 am 12:14 AM

The core strategies of MongoDB performance tuning include: 1) creating and using indexes, 2) optimizing queries, and 3) adjusting hardware configuration. Through these methods, the read and write performance of the database can be significantly improved, response time, and throughput can be improved, thereby optimizing the user experience.

How to sort mongodb index How to sort mongodb index Apr 12, 2025 am 08:45 AM

Sorting index is a type of MongoDB index that allows sorting documents in a collection by specific fields. Creating a sort index allows you to quickly sort query results without additional sorting operations. Advantages include quick sorting, override queries, and on-demand sorting. The syntax is db.collection.createIndex({ field: <sort order> }), where <sort order> is 1 (ascending order) or -1 (descending order). You can also create multi-field sorting indexes that sort multiple fields.

What are the tools to connect to mongodb What are the tools to connect to mongodb Apr 12, 2025 am 06:51 AM

The main tools for connecting to MongoDB are: 1. MongoDB Shell, suitable for quickly viewing data and performing simple operations; 2. Programming language drivers (such as PyMongo, MongoDB Java Driver, MongoDB Node.js Driver), suitable for application development, but you need to master the usage methods; 3. GUI tools (such as Robo 3T, Compass) provide a graphical interface for beginners and quick data viewing. When selecting tools, you need to consider application scenarios and technology stacks, and pay attention to connection string configuration, permission management and performance optimization, such as using connection pools and indexes.

MongoDB vs. Oracle: Data Modeling and Flexibility MongoDB vs. Oracle: Data Modeling and Flexibility Apr 11, 2025 am 12:11 AM

MongoDB is more suitable for processing unstructured data and rapid iteration, while Oracle is more suitable for scenarios that require strict data consistency and complex queries. 1.MongoDB's document model is flexible and suitable for handling complex data structures. 2. Oracle's relationship model is strict to ensure data consistency and complex query performance.

The difference between MongoDB and relational database and application scenarios The difference between MongoDB and relational database and application scenarios Apr 12, 2025 am 06:33 AM

Choosing MongoDB or relational database depends on application requirements. 1. Relational databases (such as MySQL) are suitable for applications that require high data integrity and consistency and fixed data structures, such as banking systems; 2. NoSQL databases such as MongoDB are suitable for processing massive, unstructured or semi-structured data and have low requirements for data consistency, such as social media platforms. The final choice needs to weigh the pros and cons and decide based on the actual situation. There is no perfect database, only the most suitable database.

How to set up users in mongodb How to set up users in mongodb Apr 12, 2025 am 08:51 AM

To set up a MongoDB user, follow these steps: 1. Connect to the server and create an administrator user. 2. Create a database to grant users access. 3. Use the createUser command to create a user and specify their role and database access rights. 4. Use the getUsers command to check the created user. 5. Optionally set other permissions or grant users permissions to a specific collection.

What to do if there is no transaction in mongodb What to do if there is no transaction in mongodb Apr 12, 2025 am 08:57 AM

MongoDB lacks transaction mechanisms, which makes it unable to guarantee the atomicity, consistency, isolation and durability of database operations. Alternative solutions include verification and locking mechanisms, distributed transaction coordinators, and transaction engines. When choosing an alternative solution, its complexity, performance, and data consistency requirements should be considered.

MongoDB advanced query skills to accurately obtain required data MongoDB advanced query skills to accurately obtain required data Apr 12, 2025 am 06:24 AM

This article explains the advanced MongoDB query skills, the core of which lies in mastering query operators. 1. Use $and, $or, and $not combination conditions; 2. Use $gt, $lt, $gte, and $lte for numerical comparison; 3. $regex is used for regular expression matching; 4. $in and $nin match array elements; 5. $exists determine whether the field exists; 6. $elemMatch query nested documents; 7. Aggregation Pipeline is used for more powerful data processing. Only by proficiently using these operators and techniques and paying attention to index design and performance optimization can you conduct MongoDB data queries efficiently.

See all articles