MySQL – In Detail / Intro

About my sql

MySQL – In Detail / Intro : MySQL is currently the most popular database management system software used for managing the relational database. It is open-source database software, which is supported by Oracle Company. It is fast, scalable, and easy to use database management system in comparison with Microsoft SQL Server and Oracle Database.

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.

RDBMS Terminology

Before we proceed to explain the MySQL database system, let us revise a few definitions related to the database.

DatabaseA database is a collection of tables, with related data.
TableA table is a matrix with data. A table in a database looks like a simple spreadsheet.
ColumnOne column (data element) contains data of one and the same kind, for example the column postcode.
RowA row (= tuple, entry or record) is a group of related data, for example the data of one subscription.
RedundancyStoring data twice, redundantly to make the system faster.
Primary KeyA primary key is unique. A key value can not occur twice in one table. With a key, you can only find one row.
Foreign KeyA foreign key is the linking pin between two tables.
Compound KeyA compound key (composite key) is a key that consists of multiple columns, because one column is not sufficiently unique.
IndexAn index in a database resembles an index at the back of a book.
Referential IntegrityReferential Integrity makes sure that a foreign key value always points to an existing row.

MySQL Database

MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses. MySQL is developed, marketed and supported by MySQL AB, which is a Swedish company. MySQL is becoming so popular because of many good reasons −

  • MySQL is released under an open-source license. So you have nothing to pay to use it.
  • MySQL is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.
  • MySQL uses a standard form of the well-known SQL data language.
  • MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, JAVA, etc.
  • MySQL works very quickly and works well even with large data sets.
  • MySQL is very friendly to PHP, the most appreciated language for web development.
  • MySQL supports large databases, up to 50 million rows or more in a table. The default file size limit for a table is 4GB, but you can increase this (if your operating system can handle it) to a theoretical limit of 8 million terabytes (TB).
  • MySQL is customizable. The open-source GPL license allows programmers to modify the MySQL software to fit their own specific environments.

Spread the love

Leave a Comment

Your email address will not be published. Required fields are marked *