Introduction to Mysql / Mariadb

Introduction to Mysql / Mariadb

PHP MariaDB formally known as PHP MYSQL developed in 2009 is high compatible and exact matching with MySQL APIs and commands. The original developers of MySQL created MariaDB after concerns raised by Oracle’s acquisition of MySQL.

MariaDB (and its predecessor MySQL) has been used around the world for over 20 years


Introduction to Relational Databases:

A database is as a collection of related files. A database and the tool that controls the database, called a database management system (DBMS). Most databases today are relational databases because they deal with tables containing related fields.

So let’s understand a few terms related to databases:

Database − A database is a data source containing tables of related data.

Table − A table, like a spreadsheet or excel sheet, containing data in tabular way.

Column − A column, is a structure holding data of one type.

Row − A row, sometime also known as a tuple or record is a structure grouping related data.

Primary Key − this refers to a unique, identifying value. This value cannot repeat within a table, and there can have only one primary key in the table.

Foreign Key − a foreign key serves as a link or interface between two tables.

Compound Key − A compound key is a key that refers to multiple columns.

Enjoy the tutorial? Please spread the word :)

Follow by Email