USE [DATABASE]

Syntax

USE db_name

Description

The 'USE db_name' statement tells MariaDB to use thedb_name database as the default (current) database forsubsequent statements. The database remains the default until the end of thesession or another USE statement is issued:

USE db1;
SELECT COUNT(*) FROM mytable;   # selects FROM db1.mytable
USE db2;
SELECT COUNT(*) FROM mytable;   # selects FROM db2.mytable

The DATABASE() function (SCHEMA() is a synonym) returns the default database.

Another way to set the default database is specifying its name at mariadb command line client startup.

One cannot use USE to a database one has no privileges to. The reason is thata user with no privileges to a database should not be able to know if a database exists or not.

See Also

• Identifier Qualifiers

• USE CATALOG

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}