SQL Statement
Mongo Query Language Statement
CREATE TABLE USERS (a Number, b Number) |
Implicit or use MongoDB::createCollection(). |
INSERT INTO USERS VALUES(1,1) |
$db->users->insert(array("a" => 1, "b" => 1)); |
SELECT a,b FROM users |
$db->users->find(array(), array("a" => 1, "b" => 1)); |
SELECT * FROM users WHERE age=33 |
$db->users->find(array("age" => 33)); |
SELECT a,b FROM users WHERE age=33 |
$db->users->find(array("age" => 33), array("a" => 1, "b" => 1)); |
SELECT a,b FROM users WHERE age=33 ORDER BY name |
$db->users->find(array("age" => 33), array("a" => 1, "b" => 1))->sort(array("name" => 1)); |
SELECT * FROM users WHERE age>33 |
$db->users->find(array("age" => array('$gt' => 33))); |
SELECT * FROM users WHERE age<33 |
$db->users->find(array("age" => array('$lt' => 33))); |
SELECT * FROM users WHERE name LIKE "%Joe%" |
$db->users->find(array("name" => new MongoRegex("/Joe/"))); |
SELECT * FROM users WHERE name LIKE "Joe%" |
$db->users->find(array("name" => new MongoRegex("/^Joe/"))); |
SELECT * FROM users WHERE age>33 AND age<=40 |
$db->users->find(array("age" => array('$gt' => 33, '$lte' => 40))); |
SELECT * FROM users ORDER BY name DESC |
$db->users->find()->sort(array("name" => -1)); |
CREATE INDEX myindexname ON users(name) |
$db->users->ensureIndex(array("name" => 1)); |
CREATE INDEX myindexname ON users(name,ts DESC) |
$db->users->ensureIndex(array("name" => 1, "ts" => -1)); |
SELECT * FROM users WHERE a=1 and b='q' |
$db->users->find(array("a" => 1, "b" => "q")); |
SELECT * FROM users LIMIT 10 SKIP 20 |
$db->users->find()->limit(10)->skip(20); |
SELECT * FROM users WHERE a=1 or b=2 |
$db->users->find(array('$or' => array(array("a" => 1), array("b" => 2)))); |
SELECT * FROM users LIMIT 1 |
$db->users->find()->limit(1); |
EXPLAIN SELECT * FROM users WHERE z=3 |
$db->users->find(array("z" => 3))->explain() |
SELECT DISTINCT last_name FROM users |
$db->command(array("distinct" => "users", "key" => "last_name")); |
SELECT COUNT(*y) FROM users |
$db->users->count(); |
SELECT COUNT(*y) FROM users where AGE > 30 |
$db->users->find(array("age" => array('$gt' => 30)))->count(); |
SELECT COUNT(AGE) from users |
$db->users->find(array("age" => array('$exists' => true)))->count(); |
UPDATE users SET a=1 WHERE b='q' |
$db->users->update(array("b" => "q"), array('$set' => array("a" => 1))); |
UPDATE users SET a=a+2 WHERE b='q' |
$db->users->update(array("b" => "q"), array('$inc' => array("a" => 2))); |
DELETE FROM users WHERE z="abc" |
$db->users->remove(array("z" => "abc")); |
相关推荐
报告说明了在Windows平台下,mysql和mongodb插入数据的性能时间对比。
Mongodb 查询到 sql 查询转换器。 示例:在:db.user.find({name: 'julio'}); out: SELECT * FROM user WHERE name = 'julio'; 在:db.user.find({_id: 23113},{name: 1, age: 1}); out: SELECT name, age FROM ...
mongodb与mysql SQL语句区别: ex: select * from users db.users.find();
如果您不习惯MongoDB查询语言,那么Studio3T的SQL查询可能会派上用场。编写SQL选择表达式和SQL联接来查询mongodb,并查看SQL查询如何转换为MQL——这是一个很好的工具。SQL查询语言
NoSQL数据库之MongoDB查询
千万级Mysql-MongoDB性能对比报告
sql到mongodb 将SQL表转换为MongoDB集合的Java工具 轻松将 MSSQL 表转换为 MongoDB。 从下载 SQL Server JDBC 驱动程序 将 SQLJDBC4.jar 文件放在同一文件夹中。 一次指定 TABLE NAME 和 NUMBER OF ROWS 进行导入...
MongoDB常用SQL操作,包括dml 和ddl语句,每条sql语句都有对应的示例
delphi所有笔记,还有mongodb innosetup sql等,都是比较基础的一些笔记
MongoDB常用SQL操作
mongodb 常用查询语法包括分页等用法
MongoDB高级查询用法大全
很全面的mongodb 查询语法和实例 $gt $lt $gte $lte $exists $size $type 等等
MongoDb是目前流行的No-SQL数据库,它快速简洁,比SQL Server Database快多了。美国的谷歌,脸书都用MongoDb。
SqlServer数据导入MongoDBSqlServer数据导入MongoDBSqlServer数据导入MongoDB
MongoDB基本查询.pdf 学习资料 复习资料 教学资源
MongoDB命令查询.txt
mongoDb部分查询语言和标准sql查询语言对比
官方给出的三种NoSQL数据库:SequoiaDB&Cassandra&MongoDB性能对比测试报告;值得参考;
安装Mongo数据库: 在发布本文的时间官方提供的最新版本是:1.6.5 ,如果不做特殊声明,本教程所用的版本将会是这个...记住,以上窗口不要关闭,重新开一个窗口,到D:\MongoDb输入mongo.exe你就可以查询数据库啦