MYSQL is an RDBMS (Relational Database Management System) software, which is used to manage data in the form of tables that is also called relation in a database.
The relational database was invented by E. F. Codd.
Database
The collection of tables is called a database.
Table
The collection of rows and columns is called a table.
Rows (Record)
A horizontal row in a table is called a record because it is collection of fields.
Fields (Attributes)
Vertical lines in a table are called fields.
MYSQL used in vast forms, today most of the tech companies are using MYSQL like FACEBOOK, UBER, etc.
Some key points about mysql which makes it more popular.
- It is open-source software.
- It is reliable, scalable, and easy to use.
- It is a cross-platform RDBMS.
Every table in a database is also called entities like products, users, employees.
In RDBMS two most popular keys are.
Primary Key
A key that makes a record unique in a table.
or
In a table, every row is uniquely identified by a key that is called the primary key.
Foreign Key
A key in a table pointing to the primary key in other table is called foreign key, and a foreign key may not be unique.