{"id":822,"date":"2014-12-18T23:42:21","date_gmt":"2014-12-18T23:42:21","guid":{"rendered":"http:\/\/shivdev.com\/blog\/?p=822"},"modified":"2014-12-18T23:42:21","modified_gmt":"2014-12-18T23:42:21","slug":"mongodb-for-sql-users","status":"publish","type":"post","link":"http:\/\/shivdev.com\/blog\/2014\/12\/18\/mongodb-for-sql-users\/","title":{"rendered":"MongoDB for SQL users"},"content":{"rendered":"

Here’s a Quick Reference to get started<\/p>\n

<\/p>\n\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t
Description<\/th>\n\t\tSQL<\/th>\n\t\tMongo DB<\/th>\n\t\t <\/td>\n\t<\/tr>\n\t<\/thead>\n\t
Lingo 1<\/td>\n\t\tTable; Relation<\/td>\n\t\tCollection<\/td>\n\t\t <\/td>\n\t<\/tr>\n\t
Lingo 2<\/td>\n\t\tRow; Record; Tuple<\/td>\n\t\tDocument<\/td>\n\t\t <\/td>\n\t<\/tr>\n\t
List Databases<\/td>\n\t\tSHOW databases<\/td>\n\t\tshow databases<\/td>\n\t\t <\/td>\n\t<\/tr>\n\t
List Tables<\/td>\n\t\tSHOW tables<\/td>\n\t\tshow collections<\/td>\n\t\t <\/td>\n\t<\/tr>\n\t
Switch to a DB<\/td>\n\t\tUSE db<\/td>\n\t\tuse db<\/td>\n\t\t <\/td>\n\t<\/tr>\n\t
Show Table Data<\/td>\n\t\tSELECT * FROM table<\/td>\n\t\tdb.collection.find.pretty()<\/td>\n\t\t <\/td>\n\t<\/tr>\n\t
Filter Table Data<\/td>\n\t\tWHERE colum = 'value'<\/td>\n\t\tdb.collection.find({'column':'value'})<\/td>\n\t\t <\/td>\n\t<\/tr>\n\t
Select Columns<\/td>\n\t\tSELECT col1, col2<\/td>\n\t\tdb.collection.find({},{col1:1, col2:1})<\/td>\n\t\t <\/td>\n\t<\/tr>\n\t
Delete Rows<\/td>\n\t\tDELETE FROM table WHERE col='val'<\/td>\n\t\tdb.collection.remove({'col':'val'})<\/td>\n\t\t <\/td>\n\t<\/tr>\n\t
Get Rid of a Table<\/td>\n\t\tDROP table<\/td>\n\t\tdb.collection.drop()<\/td>\n\t\t <\/td>\n\t<\/tr>\n\t
 <\/td>\n\t\t <\/td>\n\t\t <\/td>\n\t\t <\/td>\n\t<\/tr>\n<\/table>

\n<\/p>\n","protected":false},"excerpt":{"rendered":"

Here’s a Quick Reference to get started Description SQL Mongo DB   Lingo 1 Table; Relation Collection   Lingo 2 Row; Record; Tuple Document   List Databases SHOW databases show databases   List Tables SHOW tables show collections   Switch to a DB USE db use db   Show Table Data SELECT * FROM table […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[33,6],"tags":[],"_links":{"self":[{"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/posts\/822"}],"collection":[{"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/comments?post=822"}],"version-history":[{"count":2,"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/posts\/822\/revisions"}],"predecessor-version":[{"id":824,"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/posts\/822\/revisions\/824"}],"wp:attachment":[{"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/media?parent=822"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/categories?post=822"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/shivdev.com\/blog\/wp-json\/wp\/v2\/tags?post=822"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}