The USE statement tells PolarDB-X 1.0 to use the named database as the default database for subsequent operations. This topic describes how to execute the USE statement.
Background information
Note
- Before you switch between databases, ensure that you have the permissions on the databases. You can grant the permissions in the console. For more information, see Account and permission system.
- After you switch to another database, the hints and sequences in original SQL statements take effect on the new database. This rule applies if you do not specify a database in the hints or sequences.
Syntax
USE db_name
Example
You can execute the following statement to switch to a database named NEW_DB
:
USE NEW_DB