Currently, everyone can observe the rapid growth of digital information. And since most of this information is important, it becomes necessary to store it on digital media for future use. In this situation, modern technologies such as databases can be applied. They provide reliable storage of any digital information, and access to data can be carried out anywhere in the world. One of the technologies under consideration is the MySQL database management system.
MySQL DBMS - what is it?
MySQL . . , MySQL.
, , , MySQL. -. MySQL (, - . .), (-, . .). MySQL-. , .
. , , . (), .
, , . , , , . . : . . ., , , , . (6 ), , MySQL- , , . , , , . .
Employee_id | Surname | Name | Patronymic | Department_id | Position | Phone | Employer_id |
1 | | | | . | | 495**** | null |
2 | | | | . | . | 495*** | 1 |
3 | | | | | | | 1 |
… | … | … | … | … | … | … | … |
59 | | | | | -. | 495*** | 32 |
. . . «» .
MySQL – Select. , . . select. MySQL . , .
, . select. , , , from .
MySQL- , . () distinct, – where. , , , ... , «». , .
, , MySQL. ? , , . , MySQL MySQL-, . , . , MySQL-. 3-5 .
, . . , , . , MySQL-. , , , .
, , . , , , . . . , MySQL-. , , :
In this case, the any clause is used to exclude errors if there are several employees with such initials.
Summary
Summing up, it should be noted that there are many other additional features that greatly facilitate the construction of queries, since MySQL is a powerful tool with a rich arsenal of tools for storing and processing data.