Database:
A database is an organized collection of data, generally stored and accessed electronically from a computer system.
Where databases are more complex they are often developed using formal design and modeling techniques.
What is Select Database?
Basically, when we have multiple database in Mysql and you want to work only one at a time then you select that database to use using following syntax:
Syntax:
USE database_name;
Remember:
database_name is case-sensitive
Firstly check how many database we have in Mysql:
SHOW DATABASE
| Database |
|---|
| employee |
| student |
| library |
| shopping |
Now we want to use the only library database then execute following query:
USE library
output:
Database changed