Introduction
MySQL is a relational database management system based on the Structured Query Language. It is used to manage database and to manipulate data with the help of various SQL queries. It is open-source and free software supported by Oracle Company.
Queries are the most important element to play with data’s. These queries are used to insert records, update records, delete records, select records, create tables, drop tables, etc.
Database
A database is an application used to store and structure data into tables, rows, columns, and indexes to find the relevant information very quickly. Today, there are many databases available like MySQL, Sybase, Oracle, MongoDB, PostgreSQL, SQL Server, etc
Each database contains distinct API for performing database operations such as creating, managing, accessing, and searching the data it stores
MySQL
It is the most popular database management system software used for managing the relational database. It is fast, scalable, and easy to use and work with in conjunction for server side and/or web-based enterprise applications. MySQL supports many Operating Systems like Windows, Linux, MacOS, etc. and work with also C, C++, and Java languages.
What does MySQL provides
- Let us to implement database operations on tables, rows, columns, and indexes
- Let us to define relationship in the form of tables (collection of rows and columns), also known as relations
- Provides Referential Integrity between rows or columns of various tables
- Allow us to updates the table indexes automatically.
- Let us to use many SQL queries to combines useful information from multiple tables intruder to let the end-users to have the information requested.
How MySQL works?
it has a work flow of client-server architecture. This means that the client make request and the request passes through a network service and the server will give the desired output as soon as the instructions are matched
There are two things to address here MySQL database and MySQL Server. The following line address these two things separatly
- MySQL database is responsible to store data. This means creates a database that allows you to build many tables to store and manipulate data and defining the relationship between each table
- MySQL Server is responsible to handle all the database instructions, statements, or commands in order to provide the desired result to the client.
Therefore the relationship between MySQL database and MySQL server is as follow
Figure 1.1 : – Client and MySQL Relationship – Where MySQL refers both a Database and Server.
The interpretation of the above diagram is the following to let you have better understanding
- Client Send a request to the Server using GUI or any Service Call or command prompt by using specific SQL expressions on MySQL
- The Server interpret the client request and respond with the requested expressions and produce the desired result on the client-side.
Client uses different MYSQL GUI to make your data management activities faster and easier. Some of the know MySQL GUIs are MySQL Workbench, SequelPro, DBVisualizer, and the Navicat DB Admin Tool. Some GUIs are commercial, while some are free with limited functionality, and some are only compatible with MacOS