- Learn MySQL
- MySQL - Home
- MySQL - Introduction
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Connection
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Data Types
- MySQL - Create Tables
- MySQL - Drop Tables
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Where Clause
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Like Clause
- MySQL - Sorting Results
- MySQL - Using Join
- MySQL - NULL Values
- MySQL - Regexps
- MySQL - Transactions
- MySQL - Alter Command
- MySQL - Indexes
- MySQL - Temporary Tables
- MySQL - Clone Tables
- MySQL - Database Info
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - Database Export
- MySQL - Database Import
Difference between MySQL and MongoDB
MySQL is a relational database. MongoDB is NoSQL Database.
Following are the important differences between MySQL and MongoDB.
| Sr. No. | Key | MySQL | MongoDB |
|---|---|---|---|
| 1 | Owned/Developed By | MySQL is owned by Oracle. | MongoDB is developed by MongoDB Inc. |
| 2 | Data Storage | MySql stores data in tabular format as records in table. | MongoDB stores records as documents. |
| 3 | Language | SQL, Structured Query Language is used to query database. | Dynamic Schema. Predefined structure is defined for incoming data. |
| 4 | Design Objectives | No efficient replication and Sharding available. | High availability, Scalability, Replication and Sharding are inbuilt. |
| 5 | Terms | MongoDB uses Collection, Document, Field, Embedded Document, Linking etc. | MySQL uses Table, Row, Column, Joins etc. |
| 6 | Data Storage | MySQL stores data in forms of records in table. | MongoDB stores data in form of JSON like documents. |
- Related Articles
- Difference between RDBMS and MongoDB
- Difference between Hadoop and MongoDB
- Difference Between MySQL and PostgreSQL
- Difference between count() and find().count() in MongoDB?
- Difference between find() and findOne() methods in MongoDB?
- MongoDB difference between show dbs and show databases?
- Difference between MySQL and SQL Server
- Difference between “now” and a given date with MongoDB?
- Difference between NumberLong(x) and NumberLong(“x”) in MongoDB?
- Difference between Schema and Database in MySQL?
- What is the difference between SQL and MySQL?
- Difference between count(*) and count(columnName) in MySQL?
- Difference between MySQL BigInt(20) and Int(20)?
- Difference between BIGINT and BIGINT(20) in MySQL?
- Difference Between MySql NULL and IS NOT NULL?
Advertisements