Class_notes_of_Database_Management_System_Part - 5

Introduction to MySQL

,Introduction

●
MySQL is a relational database management system
based on the Structured Query Language, which is the
popular language for accessing and managing the records
in the database.
●
MySQL is open-source and free software under the GNU
license. It is supported by Oracle Company.
●
It is developed, marketed, and supported by MySQL AB, a
Swedish company, and written in C programming
language and C++ programming language

,●
MySQL is a Relational Database Management System (RDBMS)
software that provides many things, which are as follows:
– It allows us to implement database operations on tables, rows,
columns, and indexes.
– It defines the database relationship in the form of tables
(collection of rows and columns), also known as relations.
– It provides the Referential Integrity between rows or columns of
various tables.
– It allows us to updates the table indexes automatically.
– It uses many SQL queries and combines useful information from
multiple tables for the end-users.

, MySQL Features

●
MySQL is a relational database management system.
●
MySQL is easy to use.
●
It is secure.
●
Free to download
●
MySQL is considered one of the very fast database
languages.
●
MySQL is compatible to run on many operating systems.
●
MySQL is faster, more reliable, and cheaper