Introduction to MySQL

Profile picture for user arilio666
Submitted by arilio666 on

So before we get to know about what MySQL is we will get to understand the base of this MySQL which is a database.

What is a database?

  • A place where there are some collection of data/records or we can call it an application instead of a database.
  • It gives us the ease of fetching and having visions of the stored data in a more structural table format with rows columns and indexes which will be easy to fetch the relevant pieces of information as quickly as possible.
  • It has an API that helps in fetching, storing, creating, searching data it is frequently storing.

What is MySQL?

  • It is a relational database management system based on structured query language.
  • Official pronounced as My Ess Que ELL but some may call it My Sequel which is not the right pronunciation.
  • A widely used popular DBMS (database management system) where it is used to manage relational databases.
  • An open-source DB supported by oracle.
  • MySQL is so fast and scalable and most importantly is it is most easy to use when compared to the Microsoft SQL Server.
  • Mostly it works under the influence of PHP scripts to make it more dynamic.

MySQL Background

  • Developed and supported by a Swedish company named MySQL AB which is written in C language and C++ language too.
  • Many top companies currently use MySQL knowing its ultimate features.
  • It supports many operating systems like Windows, Linux, macOS that influence C, C++, and Java Programming Language.

MySQL RDBMS (Relational Database Management System)

  • The main reason it is an RDBMS is because of its main implementations on tables, rows, columns, and indexes operations.
  • Always defines the relationship of the database through table form this is what it's been called relations.
  • Can update the table indexes all by itself.
  • Many SQL queries are used to combine and query the various user-defined tables no matter they are in multiple forms.