MYSQL (RDBMS) is a relationship database management system that is open-source in nature. SQL full form is a structured query language, MYSQL is the most used relational database in the world.
MYSQL Drivers are the hardware drivers required to run the RDBMS System, MYSQL can be easily connected with back-end languages via MYSQL instances and extensions. (MYSQL integration with BACK-END Programming language can be object-oriented or procedural)
SQL is leveraged for CRUD operations, the DB server is linked with a back-end scripting language and then data can be created, removed, updated, and deleted from the database.
Backend ——–> Create Ops ———-> DB SERVER
Backend ——-> Remove Ops ———–> DB SERVER
Backend ——> Update Ops ———–> DB SERVER
Backend ——-> Delete Ops —————> DB SERVER
The CRUD operations can be carried out by MYSQL, SQL Queries have to be executed to carry out DATA FILTERING, DATA NORMALIZATION, DATA CRUD OPERATIONS, DATA PROCESSING, and DATA IMPORT / EXPORT.
DB server can run SQL Queries both with and without the scripting language, RDMBS is good for storing META -DATA but for media data, it is better to use BLOB Storage. MYSQL was developed by ORACLE CORPORATION which was initially released in 1995.
Explore MYSQL Git repo to understand the coding and low-level structure of the language. MYSQL is written in C and C++.
MYSQL is equipped with GPLV2 licenses, MYSQL is GNU (General public licenses), and also comes with propriety enterprise licenses as well.
Mysql is a part of the LAMP and XAMP stack :
L–> LINUX | A —> APACHE | M -> MYSQL | P –> PHP
X-> Windows | A-> Apache | M -> Mysql | P -> PHP
MYSQL is integrated to render database-driven web applications. MYSQL SUPPORTS THE FOLLOWING SYSTEM PLATFORMS: AIX, BSDI, HP-UX, IBMI, LINUX, MICROSOFT WINDOS, NET BSD, open BSD, Open Solaris, Oracle Solaris, Symbian, Unix wave.
Evolution of MYSQL (KEY STEPS)
- Internal release (1995)
- WINDOW VERSION (1998)
- VERSION 4.0 (2002)
- SUN MICROSYSTEMS Acquired MYSQL (2008)
- Oracle acquired Sun Microsystems (2010)
Latest release: MySQL 8.0
Diagram
The article above is rendered by integrating outputs of 1 HUMAN AGENT & 3 AI AGENTS, an amalgamation of HGI and AI to serve technology education globally. (Article By : Himanshu N)