Lists of "MySQL features" usually say fast, secure, reliable and stop there. Those words are hard to check. This page takes the features that actually matter when you choose a database or prepare for an interview, explains each in plain terms, and proves several of them with one small table you can run on MySQL 8.0. It ends with the limitations, because an honest comparison needs those too.
One table, six features
A product table for a small online store, using several MySQL 8 features at once:
CREATE TABLE products (
id INT PRIMARY KEY,
name VARCHAR(60),
price DECIMAL(10,2),
gst_pct TINYINT,
specs JSON, -- (1) JSON
price_with_gst DECIMAL(10,2)
AS (ROUND(price * (1 + gst_pct / 100), 2)) STORED, -- (2) generated column
CONSTRAINT chk_price CHECK (price > 0), -- (3) CHECK constraint
FULLTEXT KEY ft_name (name) -- (4) full-text index
);
INSERT INTO products (id, name, price, gst_pct, specs) VALUES
(1,'Steel water bottle 1 litre',450,18,'{"colour":"silver","warranty_months":6}'),
(2,'Cotton kurta, block print',899,5,'{"colour":"indigo","size":["M","L"]}'),
(3,'Bluetooth speaker with bass boost',1999,18,'{"colour":"black","warranty_months":12}');
SELECT name, price, price_with_gst,
specs->>'$.colour' AS colour, -- reading JSON
RANK() OVER (ORDER BY price DESC) AS price_rank -- (5) window function
FROM products;
| name | price | price_with_gst | colour | price_rank |
|---|---|---|---|---|
| Bluetooth speaker with bass boost | 1999.00 | 2358.82 | black | 1 |
| Cotton kurta, block print | 899.00 | 943.95 | indigo | 2 |
| Steel water bottle 1 litre | 450.00 | 531.00 | silver | 3 |
SELECT name FROM products WHERE MATCH(name) AGAINST ('speaker bass'); -- full-text search
INSERT INTO products (id, name, price, gst_pct, specs) VALUES (4,'Free sample',0,0,'{}');
| name |
|---|
| Bluetooth speaker with bass boost |
The insert is rejected with ERROR 3819: Check constraint 'chk_price' is violated, and (6) all of it is stored in InnoDB, so it is transactional. Now the features one by one.
1. Open source with a free Community Edition
MySQL Community Server is released under the GPL and costs nothing to download and use. Oracle, which owns MySQL, also sells MySQL Enterprise Edition with extra tools (for example enterprise backup, audit and monitoring) and support, and offers MySQL HeatWave as a cloud service. Students and most startups use Community Edition. If you ship MySQL inside a closed-source product you distribute, read the licence terms or talk to Oracle about a commercial licence.
2. Reliable transactions with InnoDB
The default engine, InnoDB, gives ACID transactions, row-level locking, foreign keys and crash recovery. This is what makes MySQL suitable for payments, bookings and inventory. Details: transactions and ACID properties.
3. Modern SQL in version 8.0
MySQL 8.0 closed many gaps with other databases: window functions (RANK(), LAG()), common table expressions including recursive ones, enforced CHECK constraints (from 8.0.16), functional indexes, roles, and EXPLAIN ANALYZE. Older articles saying "MySQL cannot do window functions" describe 5.7. The full list is in MySQL 8 new features.
4. Native JSON
The JSON type validates documents on insert, stores them in a binary format, and supports path queries such as specs->>'$.colour'. You can keep a fixed relational schema for core columns and flexible attributes in JSON, without adding a separate document database. See the JSON data type tutorial.
5. Replication and high availability
Built-in replication copies changes from a source server to one or more replicas, used for read scaling, reporting servers and failover. MySQL also ships Group Replication and InnoDB Cluster for automatic failover. See MySQL replication explained.
6. Security features
Accounts are tied to a host ('app'@'10.0.0.%'), privileges can be granted down to the column level, roles group privileges, the default authentication plugin in 8.0 is caching_sha2_password, and connections can be encrypted with TLS.
7. Runs everywhere, talks to everything
MySQL runs on Windows, Linux and macOS and on every major cloud (as managed services such as Amazon RDS, Azure Database for MySQL and Google Cloud SQL). Official connectors exist for Java, Python, .NET, Node.js, C/C++ and more, PHP supports it through mysqli and PDO, and BI tools such as Power BI and Tableau connect directly. That ecosystem, plus decades of tutorials and Stack Overflow answers, is a practical advantage for a learner: almost any error message you hit has been discussed somewhere.
Limitations worth knowing
- No
FULL OUTER JOIN; you emulate it withUNION(see MySQL JOINs). - Fewer advanced data types and extensions than PostgreSQL (for example, no native array type and a smaller extension ecosystem). A balanced comparison is in MySQL vs PostgreSQL.
- DDL is not transactional: a failed migration with several
ALTER TABLEstatements cannot be rolled back as one unit. - Very large analytical workloads (billions of rows, heavy aggregations) are usually better served by a columnar warehouse; MySQL is built mainly for transactional work.
Who benefits most from learning it? Anyone heading into backend development, data analysis or database administration in India will meet MySQL early, because it is common in college labs, web stacks such as LAMP, and company reporting databases. Start with what MySQL is if you are new.