Determining the Current Database
Problem
Has any database been selected as the current database? What is its name?
Solution
Use the DATABASE( )
function.
Discussion
SELECT
DATABASE( )
returns the
name of the current database, or the empty string if no database has
been selected. This Python code uses the statement to present a
status display containing information about the current connection:
cursor = conn.cursor ( ) cursor.execute ("SELECT DATABASE( )") row = cursor.fetchone ( ) cursor.close if row == None or len (row) == 0 or row[0] == "": db = "(no database selected)" else: db = row[0] print "Current database:", db
Get MySQL Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.