USE

Name

USE

Description

The USE command allows us to use the database

grammar:

  1. USE <[CATALOG_NAME].DATABASE_NAME>

illustrate:

  1. USE CATALOG_NAME.DATABASE_NAME will switch the current catalog into CATALOG_NAME and then change the current database into DATABASE_NAME

Example

  1. If the demo database exists in current catalog, try accessing it:

    1. mysql> use demo;
    2. Database changed

  2. If the demo database exists in catalog hms_catalog, try switching the catalog and accessing it:

    1. mysql> use hms_catalog.demo;
    2. Database changed

Keywords

  1. USE

Best Practice