DATABASE()
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 mysql command line client startup.
SELECT DATABASE(); +------------+ | DATABASE() | +------------+ | NULL | +------------+ USE test; Database changed SELECT DATABASE(); +------------+ | DATABASE() | +------------+ | test | +------------+
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/database/