一、SQL与MongoDB术语对比
SQL |
MongoDB |
表(Table) |
集合(Collection) |
行(Row) |
文档(Document) |
列(Col) |
字段(Field) |
主键(Primary Key) |
对象ID(ObjectId) |
索引(Index) |
索引(Index) |
嵌套表(Embeded Table) |
嵌入式文档(Embeded Document) |
数组(Array) |
数组(Array) |
二、基本操作语句
1.插入语句
①插入单条数据:insertOne()
db.getCollection('table_name').insertOne({"name":"张三","age":17,"address":"广东"})
②批量插入数据:insertMany()
db.getCollection('table_name').insertMany([
{"name":"张三","age":17,"address":"广东"},
{"name":"李四","age":22,"address":"北京"}
])
2.查询语句
①查找所有数据:find()或find({})
db.getCollection('table_name').find()
db.getCollection('table_name').find({})
②查找特定数据:find({'字段1':'值1','字段2':'值2'})
db.getCollection('table_name').find({"age":17})