6월, 2018의 게시물 표시

Import csv tsv file into MongDB

When the csv or tsv file has headerline csv $ mongoimport -d <database> -u <username> -c <collection> --type csv --headerline --file <filename> tsv $ mongoimport -d <database> -u <username> -c <collection> --type tsv --headerline --file <filename> When the csv or tsv file doesn't have headerline and set field type $ mongoimport -d <database> -u <username> -c <collection> --type tsv --columnsHaveTypes --fields "name.string(),register.boolean(),phone.int32()"  --file <filename> https://docs.mongodb.com/manual/reference/program/mongoimport/

자주쓰는 MongoDB 명령어

# remove a document on MongoDB $ db.<collection>.remove({ _id: ObjectId("id")}); # update a document  on MongoDB # change name to "bao" $ db.<collection>.update({ _id: ObjectId("") }, { $set: { name: "bao" }}); # update multi documents  on MongoDB # find all documents which type is not "t" and then change their type to "n" $ db.<collection>.update({ type: { $ne: 't' }}, { $set: { type : ''n" }}, { multi: true });