MySQL與MongoDB的操作對比

作用

MySQL

MongoDB

服務器守護進程

mysqld

mongod

客戶端工具

mysql

mongo

邏輯備份工具

mysqldump

mongodump

邏輯還原工具

mysql

mongorestore

數據導出工具

mysqldump

mongoexport

數據導入工具

source

mongoimport

新建用戶並授權

grant all on *.* 
to username@'localhost'
 identified by 'passwd';

db.addUser("user","psw")
db.auth("user","psw")

顯示庫列表

show databases;

show dbs

進去庫

use dbname;

use dbname

顯示表列表

show tables;

show collections

查詢主從狀態

show slave status;

rs.status

創建庫

create database name;

無需單獨創建，直接use進去

創建表

create table tname(id int);

無需單獨創建，直接插入數據

刪除表

drop table tname;

db.tname.drop()

刪除庫

drop database dbname;

首先進去該庫，db.dropDatabase()

插入記錄

insert into tname(id) value(2);

db.tname.insert({id:2})

刪除記錄

delete from tname where id=2;

db.tname.remove({id:2})

修改/更新記錄

update tname set id=3 
where id=2;

db.tname.update({id:2},
{$set:{id:3}},false,true)

查詢所有記錄

select * from tname;

db.tname.find()

查詢所有列

select id from tname;

db.tname.find({},{id:1})

條件查詢

select * from tname where id=2;

db.tname.find({id:2})

條件查詢

select * from tname where id < 2;

db.tname.find({id:{$lt:2}})

條件查詢

select * from tname where id >=2;

db.tname.find({id:{$gte:2}})

條件查詢

select * from tname where id=2 
and name='steve';

db.tname.find({id:2,
name:'steve'})

條件查詢

select * from tname where id=2
or name='steve';

db.tname.find($or:[{id:2},
{name:'steve'}])

條件查詢

select * from tname limit 1;

db.tname.findOne()

模煳查詢

select * from tname where name
like "%ste%";

db.tname.find({name:/ste/})

模煳查詢

select * from tname where name
like "ste%";

db.tname.find({name:/^ste/})

獲取表記錄數

select count(id) from tname;

db.tname.count()

獲取有條件
的記錄數

select count(id) from tname
where id=2;

db.tname.find({id:2}).count()

查詢時去掉
重複值

select distinct(last_name)
from tname;

db.tname.distinct('last_name')

正排序查詢

select *from tname order by id;

db.tname.find().sort({id:1})

逆排序查詢

select *from tname 
order by id desc;

db.tname.find().sort({id:-1})

取存儲路徑

explain select * from tname
where id=3;

db.tname.find({id=3}).explain()