作用
MySQL
MongoDB
服務(wù)器守護進程
mysqld
mongod
客戶端工具
mysql
mongo
邏輯備份工具
mysqldump
mongodump
邏輯還原工具
mysql
mongorestore
數(shù)據(jù)導出工具
mysqldump
mongoexport
數(shù)據(jù)導入工具
source
mongoimport
新建用戶并授權(quán)
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
查詢主從狀態(tài)
show slave status;
rs.status
創(chuàng)建庫
create database name;
無需單獨創(chuàng)建续誉，直接use進去
創(chuàng)建表
create table tname(id int);
無需單獨創(chuàng)建给郊，直接插入數(shù)據(jù)
刪除表
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/})
獲取表記錄數(shù)
select count(id) from tname;
db.tname.count()
獲取有條件
的記錄數(shù)
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()
