当前位置：网站首页>MongoDB与SQL常用语法对应表

MongoDB与SQL常用语法对应表

2020-11-06 21:24:52 【程序猿欧文】

5行代码，即可让微信小程序上架到自己的APP中 | 注册送大疆、华为、樱桃键盘！>>>

    对于经常写SQL的同学，一开始写mongoDB的语法会十分不习惯，下表整理了常见的SQL语法，函数以及相应的MongoDB对应语法，仅供参考。

 

术语及概念

SQL
 MongoDB
database database
table collection
row document
column field
index index
table joins $lookup
primary key primary key
SELECT INTO NEW_TABLE $out
MERGE INTO TABLE $merge(mongodb > 4.2)
UNION ALL $unionWith (mongodb > 4.4)
transactions transactions

 

语法对应表

SQL MongoDB

CREATE TABLE people (

    id MEDIUMINT NOT NULL

        AUTO_INCREMENT,

    user_id Varchar(30),

    age Number,

    status char(1),

    PRIMARY KEY (id)

)

db.createCollection("people")

 

db.people.insertOne( {

    user_id: "abc123",

    age: 55,

    status: "A"

 } )
ALTER TABLE people

ADD join_date DATETIME

db.people.updateMany(

    { },

    { $set: { join_date: new Date() } }

)
ALTER TABLE people

DROP COLUMN join_date

db.people.updateMany(

    { },

    { $unset: { "join_date": "" } }

)

CREATE INDEX idx_user_id_asc

ON people(user_id)

 db.people.createIndex( { user_id: 1 } )
CREATE INDEX

       idx_user_id_asc_age_desc

ON people(user_id, age DESC)

 db.people.createIndex( { user_id: 1, age: -1 } )
DROP TABLE people db.people.drop()

INSERT INTO people(user_id,

                  age,status)

VALUES ("bcd001",45,"A")

db.people.insertOne(

   { user_id: "bcd001", age: 45, status: "A" }

)
SELECT * FROM people db.people.find()

SELECT id,

       user_id,

       status

FROM people

db.people.find(

    { },

&n.........

版权声明
本文为[程序猿欧文]所创，转载请带上原文链接，感谢
https://my.oschina.net/mikeowen/blog/4556607

边栏推荐

猜你喜欢

随机推荐