Selects the default database for the current session. Subsequent queries execute against this database unless explicitly qualified by name.
USE db_nameThe 'USE db_name' statement tells MariaDB to use the db_name database as the default (current) database for subsequent statements. The database remains the default until the end of the session, or until another USE statement is issued:
The function ( is a synonym) returns the default database.
Another way to set the default database is by specifying its name when starting the command line client:
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.
This page is licensed: GPLv2, originally from
USE db1;
SELECT COUNT(*) FROM mytable; # selects FROM db1.mytable
USE db2;
SELECT COUNT(*) FROM mytable; # selects FROM db2.mytablemariadb db1 # starts the mariadb command-line client with db1 as the current database