MySQL学习记录

Databases are everywhere. So what is a database? By definition, a database is merely a structured collection of data.
【关系型数据库】
The data relating to each other by nature, e.g., a product belonged to a product category and associated with multiple tags. Therefore, we use the term relational database.

In the relational database, we model data like products, categories, tags, etc., using tables. A table contains columns and rows. It is like a spreadsheet.

【SQL】
SQL – the language of the relational database
SQL stands for the structured query language

SQL contains three parts:

1. Data definition language includes statements that help you define the database and its objects, e.g., tables, views, triggers, stored procedures, etc.
2. Data manipulation language contains statements that allow you to update and query data.
3. Data control language allows you to grant the permissions to a user to access specific data in the database.

【What is MySQL】
My is the daughter’s name of the MySQL’s co-founder, Monty Widenius.