Beginner Series: MySQL Tutorial
In terms of a relational database system MySQL has a few features to offer that help it stand out from similar platforms:
- MySQL Offers Client/Server Architecture: MySQL is both a client and server system. This means that there is a database server, which client programs can connect to.
- It’s Compatible with SQL: MySQL supports SQL (Structured Query Language).
- It Supports Views: MySQL has supported them since version 5.0.
- Stored Procedures: MySQL uses stored procedures to process data storage and retrieval.
- It Can Process SubSELECT Queries: This is a special form of query that references direct tables.
- Triggers: MySQL supports triggers like INSERT, UPDATE, and DELETE. These are executable server commands which get carried out automatically.
- Unicode: MySQL supports several sets of Unicode like Latin-1, Latin-2, and more.
- Full-Text Search: MySQL is capable of performing a full-text search for content across the database, even for information stored within it.
- Replication: MySQL database content can be replicated on multiple computers to improve database query speeds, and offer another form of protection (data backup).
- Transactions: MySQL will allow developers to create transactions or groups of commands that are always carried out together even in the event of a system failure.
- MySQL Supports Foreign Key Constraints: When working with InnoDB tables, MySQL will ensure that cross references do not link to tables that lead to nowhere.
- It Supports GIS Applications: MySQL can be used to store two-dimension geographical data, which means that it can support GIS (geographic information systems) applications.
- It Supports Multiple Languages: Through APIs (application programming interfaces) and libraries you can develop MySQL applications using a variety of languages such as C, C++, Perl, Java, PHP, Tcl, and Python.
- ODBC Interface Connector: MySQL includes support for the ODBC interface connector. Commonly used by Windows, the interface allows MySQL to be addressed by languages such as Delphi, Visual Basic, and others.
- It Supports Multiple Operating Systems: The MySQL server and client applications are supported across multiple OS versions, such as Mac OS X, Linux, Windows, Unix, and more.
- MySQL is Fast: Backed up by a number of benchmark tests, MySQL is considered a remarkably speedy database system.
Next, we’ll explore How MySQL is Different from PostgreSQL.
Disclosure of Material Connection: Some of the links in the post above are “affiliate links.” This means if you click on the link and purchase the item, I will receive an affiliate commission. Regardless, I only recommend products or services I use personally and believe will add value to my readers.