Documentation Home
X DevAPI User Guide
Download this Manual
PDF (US Ltr) - 1.4Mb
PDF (A4) - 1.4Mb


4.3.1 Collection.add()

The Collection.add() function is for storing documents in a collection, similar to the INSERT statement for an SQL database. It takes a single document or a list of documents as its argument, and is executed by the execute() function.

The collection needs to be created with the Schema.createCollection() function before documents can be inserted. To insert documents into an existing collection use the Schema.getCollection() function to retrieve the Collection object.

The following example shows how to use the Collection.add() function. The example assumes that the test schema exists and that the collection my_collection does not exist.

MySQL Shell JavaScript Code

Press CTRL+C to copy
// Create a new collection var myColl = db.createCollection('my_collection'); // Insert a document myColl.add({ name: 'Laurie', age: 19 }).execute(); // Insert several documents at once myColl.add([ { name: 'Nadya', age: 54 }, { name: 'Lukas', age: 32 } ]).execute();

MySQL Shell Python Code

Press CTRL+C to copy
# Create a new collection myColl = db.create_collection('my_collection') # Insert a document myColl.add({ 'name': 'Laurie', 'age': 19 }).execute() # Insert several documents at once myColl.add([ { 'name': 'Nadya', 'age': 54 }, { 'name': 'Lukas', 'age': 32 } ]).execute()

Node.js JavaScript Code

Press CTRL+C to copy
// Create a new collection db.createCollection('myCollection').then(function (myColl) { return Promise.all([ // Insert a document myColl .add({ name: 'Laurie', age: 19 }) .execute(), // Insert several documents at once myColl .add([ { name: 'Nadya', age: 54 }, { name: 'Lukas', age: 32 } ]) .execute() ]) });

C# Code

Press CTRL+C to copy
// Assumptions: test schema assigned to db, my_collection collection not exists // Create a new collection var myColl = db.CreateCollection("my_collection"); // Insert a document myColl.Add(new { name = "Laurie", age = 19 }).Execute(); // Insert several documents at once myColl.Add(new[] { new { name = "Nadya", age = 54 }, new { name = "Lukas", age = 32 } }).Execute();

Python Code

Press CTRL+C to copy
# Create a new collection my_coll = my_schema.create_collection('my_collection') # Insert a document my_coll.add({ 'name': 'Laurie', 'age': 19 }).execute() # Insert several documents at once my_coll.add([ { 'name': 'Nadya', 'age': 54 }, { 'name': 'Lukas', 'age': 32 } ]).execute()

Java Code

Press CTRL+C to copy
// Create a new collection Collection coll = db.createCollection("payments"); // Insert a document coll.add("{ \"name\":\"Laurie\", \"age\":19 }").execute(); // Insert several documents at once coll.add("{ \"name\":\"Nadya\", \"age\":54 }", "{ \"name\":\"Lukas\", \"age\":32 }").execute();

C++ Code

Press CTRL+C to copy
// Create a new collection Collection coll = db.createCollection("payments"); // Insert a document coll.add(R"({ "name":"Laurie", "age":19 })").execute(); // Insert several documents at once std::list<DbDoc> docs = { DbDoc(R"({ "name":"Nadya", "age":54 })"), DbDoc(R"({ "name":"Lukas", "age":32 })") }; coll.add(docs).execute();

See also CollectionAddFunction for the syntax of add() in EBNF.