MySQL的SQL与MongoDB命令语法对比.doc

MySQL - MongoDB命令行工具及SQL语法对比 关系数据库的一般由数据库（database）、表（table）、记录（record）三个层次概念组成，MongoDB是由数据库（database）、集合（collection）、文档对象（document）三个层次组成。MongoDB对于关系型数据库里的表，但是集合中没有列、行和关系概念。 MySQLMongoDB说明mysqldmongod服务器守护进程mysqlmongo客户端工具mysqldumpmongodump逻辑备份工具mysqlmongorestore逻辑恢复工具db.repairDatabase()修复数据库mysqldumpmongoexport数据导出工具sourcemongoimport数据导入工具grant * privileges on *.* to …Db.addUser() Db.auth()新建用户并权限show databasesshowdbs显示库列表Show tablesShow collections显示表列表Show slave statusRs.status查询主从状态Create table users(a int, b int)db.createCollection(mycoll, {capped:true, size:100000})另：可隐式创建表。创建表Create INDEX idxname ON users(name)db.users.ensureIndex({name:1})创建索引Create INDEX idxname ON users(name,ts DESC)db.users.ensureIndex({name:1,ts:-1})创建索引Insert into users values(1, 1)db.users.insert({a:1, b:1})插入记录Select a, b from usersdb.users.find({},{a:1, b:1})查询表Select * from usersdb.users.find()查询表Select * from users where age=33db.users.find({age:33})条件查询Select a, b from users where age=33db.users.find({age:33},{a:1, b:1})条件查询select * from users where age33db.users.find({age:{$lt:33}})条件查询select * from users where age33 and age=40db.users.find({age:{$gt:33,$lte:40}})条件查询select* from users wherea=1 and b=qdb.users.find({a:1,b:q})条件查询select* from users wherea=1 or b=2db.users.find( { $or : [ { a : 1 } , { b : 2 } ] } )条件查询select* from users limit 1db.users.findOne()条件查询select* from users wherename like %Joe%db.users.find({name:/Joe/})模糊查询select* from users wherename likeJoe%db.users.find({name:/^Joe/})模糊查询select count(1) from usersDb.users.count()获取表记录数select count(1) from users where age30db.users.find({age: {$gt: 30}}).count()获取表记录数selectDISTINCT last_namefrom usersdb.users.distinct(last_name)去掉重复值select* from users ORDER BY namedb.users.find().sort({name:-1})排序select* from users ORDER BY name DESCdb.users.find().sort({name:-1})排序EXPLAIN select* from users