MySQL is a open source relational database management system that allow you to manage relational databases.
Database is a collection of data or records organised in a table in rows and columns.
Suppose there is an user system. User wants to save an enquiry from a web page – enquiry form to database.
Here, User has to take help of DBMS in order to store enquiry form data to database. So, DBMS is a software which helps an user to store their data to database.
Everytime user sends a enquiry or record to database. It first go to DBMS which manage the data. Then it go to database and save.
DBMS helps to establish communication between user and database.
Some DBMS softwares are used :
There are two types of database
1. Relational – Relational databases are defined by relationships in the data of different or same table with the help of primary and foreign keys. In relational database, all records are saved in tables that looks similar to Excel spreadsheet.
These types of databases are very useful for transactions.
example – product, stock, product_order, order, supplier, customer etc. are tables which are relational.
RDMS uses SQL (Structured Query Language).
Some popular RDMS are : Oracle, MySQL, MS SQL Server, PostgreSQL.
2. NoSQL – In NoSQL database, data are not saved in tables. NoSQL databases are document based.
some popular NoSQL DBMS are MongoDB, Redis, Cassandra etc.
Popular websites around the world using MySQL