SQL Select Database

If you have multiple databases and you want to perform the operation in the database then firstly select database after that you can perform the operation.

Syntax:-


USE databaseName

Now, firstly check the all database through below command


SHOW DATABASES;

Output:-


+--------------------+
| Database           |
+--------------------+
| information_schema |
| email_archive      |
| flood              |
| employee_system    |
| performance_schema |

Now, you want to work in employee_system then use below command

Example:-


USE employee_system;