MySQL default schema

Question

Thanks to the "USE" command, I can set the default scheme; Is there a similar command to get the default schema name?

Answer 1

SELECT DATABASE(); gotta do the trick. Note that this will return NULL if no schema is currently selected.

Answer 2

Mysql provides a function for this:

 SELECT database(); 

Answer 3

You may have DBMS status using the STATUS command.

 mysql> STATUS Connection id: Current database: Current user: SSL: Current pager: Using outfile: Using delimiter: Server: Server version: Protocol version: Connection: Server characterset: Db characterset: Client characterset: Conn. characterset: UNIX socket: Uptime: 

DBMS status also has a Current Database parameter.