{"id":48508,"date":"2019-02-04T09:20:55","date_gmt":"2019-02-04T03:50:55","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=48508"},"modified":"2021-05-09T13:07:20","modified_gmt":"2021-05-09T07:37:20","slug":"mongodb-auto-increment-sequence","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/mongodb-auto-increment-sequence\/","title":{"rendered":"Generate MongoDB Auto Increment Sequence – In 7 Steps"},"content":{"rendered":"

In the last tutorial, we had learned about MongoDB Covered & Analyzing Query<\/strong>. Now we will discuss what is\u00a0MongoDB Auto Increment sequence. <\/strong>Along with this, we will learn steps to generate auto increment sequence with an example.<\/p>\n

\"MongoDB<\/a>

How to MongoDB Auto Increment Sequence?<\/p><\/div>\n

How MongoDB Auto Increment Sequence Works?<\/h2>\n

MongoDB does not support auto-increment functionality as it is available in SQL databases. We all may be familiar with MongoDB\u2019s 12-byte ObjectId which is used as a primary key to identify documents within a collection uniquely.<\/p>\n

But this is not fit for real-time operations in our day to day life. Although MongoDB does not support autoincrement sequence as a default feature, this functionality can be achieved programmatically with the help of using a counter collection.<\/p>\n

Using Counter Collection to generate a sequence-<\/strong><\/p>\n

In the below condition, we require the _id field for auto incremented integer sequence. This will start with 1,2,3,4,5 and so on.<\/p>\n

{\r\n   \"_id\":1,\r\n   \"item_short_name\": \"ABC\",\r\n   \"specification\": \"Book\",\r\n   \"category\": \"fictional\",\r\n   \"seller\": \"best_buy\",\r\n   \"network\": \"XYZ\",\r\n   \"plan\": \"regular\"\r\n}<\/pre>\n
How to Generate Auto Increment Sequence in MongoDB?<\/h2>\n
Let’s use the following steps to generate the\u00a0MongoDB auto increment sequence\u00a0for the item id:<\/p>\n
\n
\n
\n
\n
\n
    \n
  1. Generate sample collection<\/span><\/li>\n
  2. Insert a document into a collection<\/li>\n
  3. Insert the record into a collection<\/li>\n
  4. Database sequence<\/li>\n
  5. Create a JavaScript function<\/li>\n
  6. Use JavaScript function<\/li>\n
  7. View inserted a record from store collection<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n
    i. Generate sample collection<\/h4>\n
    To generate a sample collection using the following syntax. This counter will keep track of the last sequence value for all the sequence fields, as it is done in the case of a traditional database sequence.<\/p>\n
    > db.createCollection(\"sample\")\r\n{ \"ok\" : 1 }\r\n><\/pre>\n
    ii. Insert a document in a collection<\/h4>\n
    Insert the below document in sample collection which is having item_id as its key.<\/p>\n
    {\r\n   \"_id\" : \"item_id\",\r\n   \"sequence_value\": 0\r\n}<\/pre>\n
    iii. Insert the record into a collection<\/h4>\n
    Use the given below syntax to insert the above record into sample collection.<\/p>\n
    > db.sample.insert ( {_id: \"item_id\" , sequence_value : 0 } )\r\nWriteResult ( { \"nInserted\" : 1 } )\r\n><\/pre>\n
    iv. Database Sequence<\/h4>\n
    Now use this sample collection as a database sequence in order to auto generate the item_id as shown below:<\/p>\n
    > db.sample.insert ( {_id: \"item_id\" , sequence_value : 0 } )\r\nWriteResult ( { \"nInserted\" : 1 } )\r\n><\/pre>\n
    v. Create a JavaScript Function<\/h4>\n
    Here, create a JavaScript function to increment the value of the sequence_value field of the sample collection, as shown below:<\/p>\n
    > function getValueForNextSequence(sequenceOfName){\r\n...\r\n...   var sequenceDoc = db.sample.findAndModify({\r\n...     query:{_id: sequenceOfName },\r\n...      update: {$inc:{sequence_value:1}},\r\n...      new:true\r\n...    });\r\n...\r\n...     return sequenceDoc.sequence_value;\r\n... }\r\n><\/pre>\n
    vi. Use JavaScript Function<\/h4>\n
    Now we are going to use this JavaScript function in order to generate an auto increment sequence value of step 1 as the item_id. The following are the database scripts.<\/p>\n
    > db.STORE.insert({\r\n... \"_id\": getValueForNextSequence(\"item_id\"),\r\n... \"item_short_name\": \"ABC\",\r\n... \"specification\": \"book\",\r\n... \"category\": \"fictional\",\r\n... \"seller\": \"best_buy\",\r\n... \"network\": \"XYZ\",\r\n... \"plan\": \"regular\"\r\n... })\r\nWriteResult({ \"nInserted\" : 1 })\r\n> db.STORE.insert({\r\n... \"_id\": getValueForNextSequence(\"item_id\"),\r\n... \"item_short_name\": \"DEF\",\r\n... \"specification\": \"book\",\r\n... \"category\": \"fictional\",\r\n... \"seller\": \"best_buy\",\r\n... \"network\": \"GHI\",\r\n... \"plan\": \"premium\"\r\n... })\r\nWriteResult({ \"nInserted\" : 1 })\r\n> db.STORE.insert({\r\n... \"_id\": getValueForNextSequence(\"item_id\"),\r\n... \"item_short_name\": \"JKL\",\r\n... \"specification\": \"books\",\r\n... \"category\": \"non-fictional\",\r\n... \"seller\": \"best_buy\",\r\n... \"network\": \"MNO\",\r\n... \"plan\": \"corporate\"\r\n... })\r\nWriteResult({ \"nInserted\" : 1 })\r\n><\/pre>\n
    vii. View inserted record from store collection<\/h4>\n
    Now we can view the inserted records from the STORE collection by using the find and pretty methods.<\/p>\n
    > db.STORE.find().pretty()\r\n{\r\n    \"_id\" : 1,\r\n    \"item_short_name\" : \"ABC\",\r\n    \"specification\" : \"fictional\",\r\n    \"category\" : \"books\",\r\n    \"seller\" : \"best_buy\",\r\n    \"network\" : \"XYZ\",\r\n    \"plan\" : \"regular\"\r\n}\r\n{\r\n    \"_id\" : 2,\r\n    \"item_short_name\" : \"DEF\",\r\n    \"specification\" : \"fictional\",\r\n    \"category\" : \"books\",\r\n    \"seller\" : \"best_buy\",\r\n    \"network\" : \"GHI\",\r\n    \"plan\" : \"premium\"\r\n}\r\n{\r\n    \"_id\" : 3,\r\n    \"item_short_name\" : \"JKL\",\r\n    \"specification\" : \"non-fictional\",\r\n    \"category\" : \"books\",\r\n    \"seller\" : \"best_buy\",\r\n    \"network\" : \"MNO\",\r\n    \"plan\" : \"corporate\"\r\n}\r\n><\/pre>\n
    So, by using the following steps, we can create\u00a0a\u00a0MongoDB auto increment sequence.<\/p>\n
    Summary<\/h2>\n
    Hence, we have studied the 7 steps to generate MongoDB\u00a0auto increment sequence with JavaScript function and example. Furthermore, if you have any query, feel free to ask in the comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"
    In the last tutorial, we had learned about MongoDB Covered & Analyzing Query. Now we will discuss what is\u00a0MongoDB Auto Increment sequence. Along with this, we will learn steps to generate auto increment sequence...<\/p>\n","protected":false},"author":6,"featured_media":48540,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[38],"tags":[18675,18676,18674,18673],"class_list":["post-48508","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mongodb","tag-auto-increment-in-mongodb","tag-javascript-function","tag-mongodb-auto-increment","tag-mongodb-auto-increment-sequence"],"yoast_head":"\nGenerate MongoDB Auto Increment Sequence - In 7 Steps - DataFlair<\/title>\n<meta name=\"description\" content=\"How to create MongoDB Auto Increment Sequence, learn in 7 steps with JavaScript Function and example of collection and database\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/mongodb-auto-increment-sequence\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Generate MongoDB Auto Increment Sequence - In 7 Steps - DataFlair\" \/>\n<meta property=\"og:description\" content=\"How to create MongoDB Auto Increment Sequence, learn in 7 steps with JavaScript Function and example of collection and database\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/mongodb-auto-increment-sequence\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2019-02-04T03:50:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-09T07:37:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/02\/MongoDB-Auto-Increment-Sequence-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Generate MongoDB Auto Increment Sequence - In 7 Steps - DataFlair","description":"How to create MongoDB Auto Increment Sequence, learn in 7 steps with JavaScript Function and example of collection and database","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/mongodb-auto-increment-sequence\/","og_locale":"en_US","og_type":"article","og_title":"Generate MongoDB Auto Increment Sequence - In 7 Steps - DataFlair","og_description":"How to create MongoDB Auto Increment Sequence, learn in 7 steps with JavaScript Function and example of collection and database","og_url":"https:\/\/data-flair.training\/blogs\/mongodb-auto-increment-sequence\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-02-04T03:50:55+00:00","article_modified_time":"2021-05-09T07:37:20+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/02\/MongoDB-Auto-Increment-Sequence-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/mongodb-auto-increment-sequence\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/mongodb-auto-increment-sequence\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Generate MongoDB Auto Increment Sequence – In 7 Steps","datePublished":"2019-02-04T03:50:55+00:00","dateModified":"2021-05-09T07:37:20+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/mongodb-auto-increment-sequence\/"},"wordCount":461,"commentCount":2,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/mongodb-auto-increment-sequence\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/02\/MongoDB-Auto-Increment-Sequence-01.jpg","keywords":["Auto Increment in MongoDB","JavaScript Function","MongoDB Auto Increment","MongoDB Auto Increment Sequence"],"articleSection":["MongoDB Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/mongodb-auto-increment-sequence\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/mongodb-auto-increment-sequence\/","url":"https:\/\/data-flair.training\/blogs\/mongodb-auto-increment-sequence\/","name":"Generate MongoDB Auto Increment Sequence - In 7 Steps - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/mongodb-auto-increment-sequence\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/mongodb-auto-increment-sequence\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/02\/MongoDB-Auto-Increment-Sequence-01.jpg","datePublished":"2019-02-04T03:50:55+00:00","dateModified":"2021-05-09T07:37:20+00:00","description":"How to create MongoDB Auto Increment Sequence, learn in 7 steps with JavaScript Function and example of collection and database","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/mongodb-auto-increment-sequence\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/mongodb-auto-increment-sequence\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/mongodb-auto-increment-sequence\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/02\/MongoDB-Auto-Increment-Sequence-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/02\/MongoDB-Auto-Increment-Sequence-01.jpg","width":1200,"height":628,"caption":"How to MongoDB Auto Increment Sequence?"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/mongodb-auto-increment-sequence\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"MongoDB Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/mongodb\/"},{"@type":"ListItem","position":3,"name":"Generate MongoDB Auto Increment Sequence – In 7 Steps"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/48508","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=48508"}],"version-history":[{"count":7,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/48508\/revisions"}],"predecessor-version":[{"id":93180,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/48508\/revisions\/93180"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/48540"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=48508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=48508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=48508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}