2010. 12. 30. 15:12
Brain Trainning/NoSQL
뭔가 이해가 갈 듯 하면서도 약간은 어색하네요 흠...
SQL to Mongo Mapping
Chart
This page not done.
Please help us finish it!
MySQL Program |
Mongo Program |
mysqld |
mongod |
mysql |
mongo |
MongoDB queries are
expressed as JSON (BSON) objects. This quick reference chart shows examples
as both SQL and in Mongo Query Language syntax.
The query expression
in MongoDB (and other things, such as index key patterns) is represented as
JSON. However, the actual verb (e.g. "find") is done in one's
regular programming language. The exact forms of these verbs vary by
language. The examples below are Javascript and can be executed from the mongo shell.
SQL Statement |
Mongo Query Language
Statement |
CREATE TABLE USERS (a Number, b Number) |
implicit;
can be done explicitly |
INSERT INTO USERS VALUES(1,1) |
db.users.insert({a:1,b:1}) |
SELECT a,b FROM users |
db.users.find({}, {a:1,b:1}) |
SELECT * FROM users |
db.users.find() |
SELECT * FROM users WHERE age=33 |
db.users.find({age:33}) |
SELECT a,b FROM users WHERE age=33 |
db.users.find({age:33}, {a:1,b:1}) |
SELECT * FROM users WHERE age=33 ORDER BY name |
db.users.find({age:33}).sort({name:1}) |
SELECT * FROM users WHERE age>33 |
db.users.find({'age':{$gt:33}})}) |
SELECT * FROM users WHERE age<33 |
db.users.find({'age':{$lt:33}})}) |
SELECT * FROM users WHERE age>33 AND age<=40 |
db.users.find({'age':{$gt:33,$lte:40}})}) |
SELECT * FROM users ORDER BY name DESC |
db.users.find().sort({name:-1}) |
CREATE INDEX myindexname ON users(name) |
db.users.ensureIndex({name:1}) |
SELECT * FROM users WHERE a=1 and b='q' |
db.users.find({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( { $or : [ { a : 1 } , { b : 2 } ] } ) |
SELECT * FROM users LIMIT 1 |
db.users.findOne() |
EXPLAIN SELECT * FROM users WHERE z=3 |
db.users.find({z:3}).explain() |
SELECT DISTINCT last_name FROM users |
db.users.distinct('last_name') |
SELECT COUNT(*y) FROM users |
db.users.count() |
SELECT COUNT(*y) FROM users where AGE > 30 |
db.users.find({age: {'$gt': 30}}).count() |
SELECT COUNT(AGE) from users |
db.users.find({age: {'$exists': true}}).count() |
UPDATE users SET a=1 WHERE b='q' |
db.users.update({b:'q'}, {$set:{a:1}}, false, true) |
The MongoDB Manual
Pages are a good place to learn more.
'Brain Trainning > NoSQL' 카테고리의 다른 글
[MongoDB] 몽고디비 Capped Collection (0) | 2011.01.05 |
---|---|
몽고디비 (MongoDB) 다운로드 (0) | 2010.12.30 |
Programming CouchDB with Javascript (0) | 2010.12.29 |
Document Databases Compared: CouchDB, MongoDB, RavenDB (0) | 2010.12.29 |
MongoDB vs. SQL Server - INSERT comparison part deux (0) | 2010.12.29 |