DATABASE
Syntax
DATABASE() SCHEMA()
Description
Returns the default (current) database name as a string in the utf8 character set. If there is no default database, DATABASE() returns NULL. Within a stored routine, the default database is the database that the routine is associated with, which is not necessarily the same as the database that is the default in the calling context.
SCHEMA() is a synonym for DATABASE().
To select a default database, the USE statement can be run. Another way to set the default database is specifying its name at mariadb command line client startup.
Examples
SELECT DATABASE(); +------------+ | DATABASE() | +------------+ | NULL | +------------+ USE test; Database changed SELECT DATABASE(); +------------+ | DATABASE() | +------------+ | test | +------------+
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.