Using the Database
After we create a database, we have to let the DBMS know that we want to use this database. This is because the DBMS may be managing more than one databases concurrently. We have to let it know that all subsequent code that we write applies to the stated database.
To do that, we use the following syntax:
USE name_of_database;
For instance, to use the companyHR database, we write
USE companyHR;