MySQL is an open source relational database management system based on Structured Query Language.
The technology runs on virtually all platforms, including Linux, UNIX, and Windows. Although it can be used in a wide range of applications, MySQL is most often associated with web-based applications and online publishing and is an important component of an open source enterprise stack called LAMP.
The MySQL Database Server is very fast, reliable, scalable, and easy to use
This Server was originally developed to handle large databases much faster than existing solutions and has been successfully used in highly demanding production environments for several years.
Although under constant development, it offers a rich and useful set of functions. Its connectivity, speed, and security make MySQL Server highly suited for accessing databases on the Internet.
Is written in C and C++ and great adaptation to different development environments.
- Relational Database System: Like almost all other database systems on the market, MySQL is a relational database system.
- Client/Server Architecture: MySQL is a client/server system. There is a database server (MySQL) and arbitrarily many clients (application programs), which communicate with the server.
- SQL compatibility: supports as its database language — as its name suggests – SQL.
- SubSELECTs: Since version 4.1, is capable of processing a query in the form SELECT * FROM table1 WHERE x IN
- Stored procedures: Here we are dealing with SQL code that is stored in the database system.
- Replication: Replication allows the contents of a database to be copied (replicated) onto a number of computers