MongoDB Study Notes 2-data import from MongoDB Databases

1. Import CSV data
 
The content of the user.csv file is as follows:
 
_ Id, name, age
ObjectID (4eed9f9ca939118694cf05e4), "ming", 10
ObjectID (4ef1f3cf3bd18218e6bdfa31), "lisi", 20
 
 
 
You can import the data in user.csv to the user set of the localdb database in the following way:
 
> Export Import-d localdb-c user -- type csv -- file user.csv -- headerline -- upsert
 
 
 
2. import data in json format
 
The data in the user. dat file is in json format and the content is:
 
{"_ Id": "ObjectID (4eed9f9ca939118694cf05e4)", "name": "ming", "age": 10}
{"_ Id": "ObjectID (4ef1f3cf3bd18218e6bdfa31)", "name": "lisi", "age": 20}
 
You can import the data as follows:
 
> Export Import-d localdb-c user <user. dat
 
 
 
3. Parameter meaning
 
-D: Specifies the database to which the data is imported.
 
-C: Specifies the collection to which the data is imported.
 
-- Type specifies the imported data type
 
-- File: Specifies the file from which data is imported.
 
-- Headerline is only applicable to importing csv and tsv data, indicating that the first row in the file is used as the data header.
 
-- Upsert: import data by adding or updating data.