Can we use the “.” symbol in MongoDB collection name?

Yes, we can use the “.” symbol in MongoDB collection name. Let us create a collection with documents −

> db.getCollection('demo28.example');
web.demo28.example
>
>
> db.getCollection('demo28.example').insertOne({"Name":"Chris","Age":32});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e15fbe48f2315c2efc48e6b")
}
> db.getCollection('demo28.example').insertOne({"Name":"Bob","Age":31});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e15fbec8f2315c2efc48e6c")
}
> db.getCollection('demo28.example').insertOne({"Name":"David","Age":33});
{
   "acknowledged" : true,
   "insertedId" : ObjectId("5e15fbf38f2315c2efc48e6d")
}

Display all documents from a collection with the help of find() method −

> db.getCollection('demo28.example').find().pretty();

This will produce the following output −

{
   "_id" : ObjectId("5e15fbe48f2315c2efc48e6b"),
   "Name" : "Chris",
   "Age" : 32
}
{ "_id" : ObjectId("5e15fbec8f2315c2efc48e6c"), "Name" : "Bob", "Age" : 31 }
{
   "_id" : ObjectId("5e15fbf38f2315c2efc48e6d"),
   "Name" : "David",
   "Age" : 33
}

AmitDiwan

Published on 02-Apr-2020 12:28:42

• Related Questions & Answers
• Find the MongoDB collection size for name “Chris”
• Can we use “rank” as column name with MySQL8?
• Why can't we use column name “desc” in MySQL?
• Can we use “When” as column name in CREATE TABLE statement?
• Can we use “LIKE concat()” in a MySQL query?
• Can we use “IF NOT IN” in a MySQL procedure?
• MongoDB: How to query a collection named “version”?
• Should I name the username field in my MySQL table “name” or “user_name”?
• MongoDB regular expression to fetch record with specific name “John”, instead of “john”
• What is the usage of “@” symbol in MySQL stored procedure?
• Can we use “year” as a column came in a MySQL Table?
• Change collection name in MongoDB?
• MongoDB query to fetch only the “Name” field based on roles?
• “Toggle” query in MongoDB?
• Get all embedded documents with “isMarried” status in a MongoDB collection