MySQL in a Nutshell, 2nd Edition

Name

DATABASE()

Synopsis

DATABASE()

This function returns the name of the database currently in use for the session. There are no arguments. If no database has been set to default yet, it returns NULL; prior to version 4.1.1 of MySQL, it returns an empty string. Here is an example:

SELECT DATABASE( );

+--------------------+
| DATABASE( )        |
+--------------------+
| company_database   |
+--------------------+

As of version 5.0.2 of MySQL, SCHEMA() has been introduced as a synonym for DATABASE().