Create a database and a collection and write data - ApsaraDB for MongoDB

This topic describes how to create a database and a collection and write data to the collection on an ApsaraDB for MongoDB instance which is connected by using Data Management (DMS).

Prerequisites

The following steps described in Quick Start are complete:

Procedure

On the SQL Console page in the DMS console, run the following command to create a database named test:
```
use test
```
After the database is created, click the database name in the Execution History field.
In the test database, run the following command to create a collection named mongo:
```
db.createCollection("mongo")
```
If a value of 1.0 is returned for ok, the collection is created. Otherwise, the collection failed to be created.
Run the following command to write the following data to the mongo collection: {"name": "test"} and {"count": "10"}.
```
db.runCommand({insert: "mongo", documents: [{"name": "test"},{"count": "10"}]})
```

Run the following command to query the data stored in the mongo collection:

db.getCollection("mongo").find({})

The following result is returned:

[
    {
        '_id': ObjectId("63bd29f8e52fddefeb59****"),
        'name': "test"
    },    {
        '_id': ObjectId("63bd29f8e52fddefeb59****"),
        'count': "10"
    }
]