SQL 说明 |
Mongo 说明 |
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 |
$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”)); |
相关推荐
如果您不习惯MongoDB查询语言,那么Studio3T的SQL查询可能会派上用场。编写SQL选择表达式和SQL联接来查询mongodb,并查看SQL查询如何转换为MQL——这是一个很好的工具。SQL查询语言
将SQL表转换为MongoDB集合的Java工具 轻松将 MSSQL 表转换为 MongoDB。 从下载 SQL Server JDBC 驱动程序 将 SQLJDBC4.jar 文件放在同一文件夹中。 一次指定 TABLE NAME 和 NUMBER OF ROWS 进行导入。 java -...
NoSQL数据库之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 ...
SqlServer数据导入MongoDBSqlServer数据导入MongoDBSqlServer数据导入MongoDB
5. 易于使用的文档查看器和编辑器树,表和JSON视图模式 6. 数据库,收集,索引,用户,角色和功能:所有蒙戈对象的简单查看和管理 7. SSH隧道为蒙戈连接 8. 地图,减少操作的编辑器 9. 文件管理器工具GridFS的工作 ...
mongodb 常用查询语法包括分页等用法
MongoDB高级查询用法大全
mongoDB实现企业bom表多试图转化技术
很全面的mongodb 查询语法和实例 $gt $lt $gte $lte $exists $size $type 等等
MongoDB常用SQL操作,包括dml 和ddl语句,每条sql语句都有对应的示例
MongoDB命令查询.txt
MongoDB基本查询.pdf 学习资料 复习资料 教学资源
主要介绍了Thinkphp使用mongodb数据库实现多条件查询方法,修改了mongodb驱动文件来实现复合查询、多条件查询,需要的朋友可以参考下
flink-sql-connector-mongodb-cdc 2.5-SNAPSHOT
mongodb与mysql SQL语句区别: ex: select * from users db.users.find();
MongoDB常用SQL操作
函数计算访问数据库示例集(MySQL、SQLServer、MongoDB、Redis)
主要介绍了使用aggregate在MongoDB中查询重复数据记录的方法的相关资料,需要的朋友可以参考下
主要为大家详细介绍了SqlServer与MongoDB结合使用NHibernate的相关资料,具有一定的参考价值,感兴趣的小伙伴们可以参考一下