SELECT
DATABASE()
returns the name of the
default database or NULL
if no
database has been selected. The following Ruby code uses the statement
to present a status display containing information about the current
connection:
db = dbh.select_one("SELECT DATABASE()")[0] puts "Default database: " + (db.nil? ? "(no database selected)" : db)
Note that before MySQL 4.1.1, DATABASE()
returns an empty string
(not NULL
) if there is no current
database.
18.118.93.175