Introduction to MySQL and MongoDB with Comparison and Basic CRUD Operations

Whether it is a Valentine's Day post or a promotional message, the author declares that they will focus on coding, specifically on databases.

MySQL Overview

MySQL is the world’s most popular open‑source relational database, owned by Oracle. Although Oracle’s commercial database still holds a large market share, many companies, including Alibaba, are migrating to MySQL because it is free and open‑source.

MongoDB Overview

MongoDB is a widely used open‑source NoSQL database. Unlike MySQL, it stores data as flexible JSON‑like documents, which makes it attractive to startups and many backend developers who need a schema‑less solution.

MySQL vs MongoDB Comparison

MySQL has a longer history and greater maturity, while MongoDB is newer.

MySQL requires a fixed schema (though recent versions support JSON), whereas MongoDB stores data in flexible document format.

MySQL supports transactions natively; MongoDB can only achieve transactions through indirect methods.

Both databases can be deployed in distributed clusters.

Performance and optimization depend on specific use cases and personal experience.

Simple CRUD Operations

The following examples show how to query, insert, update, and delete records in both MySQL and MongoDB.

SELECT * FROM student WHERE sno = 123;

db.student.find({ 'sno' : 123 });

INSERT INTO student (sno, name) VALUES (456, 'kate');

db.student.insert({ 'sno' : 456, 'name': 'kate' });

UPDATE student SET name = 'curry' WHERE sno = 123;

db.student.update({ 'sno': 123 }, { $set : { 'name' : 'curry' } });

DELETE FROM student WHERE name = 'kate';

db.student.remove({ 'name' : 'kate' });

In summary, MySQL and MongoDB each have distinct strengths as relational and non‑relational databases; the choice depends on the specific business scenario, and they are not mutually exclusive.