MySQL determine which database is selected

Question

After calling mysql select db to grab a database  is there any way to later output the name of the database that is currently selected  This seems very basic but I couldn t find anything on php net or stackoverflow  all results are for  no database selected

User · Answer

In the comments of http   www php net manual de function mysql-db-name php I found this one from ericpp   bigfoot com    If you just need the current database name  you can use MySQL s SELECT DATABASE   command    lt  php function mysql current db          r   mysql query  SELECT DATABASE     or die mysql error         return mysql result  r 0       gt

User · Answer

You can always use STATUS command to get to know Current database  amp  Current User

User · Answer

SELECT DATABASE      p s  I didn t want to take the liberty of modifying  cwallenpoole s answer to reflect the fact that this is a MySQL question and not an Oracle question and doesn t need DUAL

User · Answer

slightly off-topic  using the CLI instead of PHP   but still worth knowing  You can set the prompt to display the default database by using any of the following  mysql --prompt   d gt    export MYSQL PS1   d gt      or once inside  prompt  d gt     R  d gt

User · Answer

Another way for filtering the database with specific word   SHOW DATABASES WHERE  Database  LIKE   lt yourDatabasePrefixHere gt    or SHOW DATABASES LIKE   lt yourDatabasePrefixHere gt       Example   SHOW DATABASES WHERE  Database  LIKE  foobar   foobar animal foobar humans gender foobar objects

User · Answer

Just use mysql query  or mysqli query  even better  or use PDO  best of all  with    SELECT DATABASE   FROM DUAL      Addendum   There is much discussion over whether or not FROM DUAL should be included in this or not  On a technical level  it is a holdover from Oracle and can safely be removed  If you are inclined  you can use the following instead   SELECT DATABASE      That said  it is perhaps important to note  that while FROM DUAL does not actually do anything  it is valid MySQL syntax  From a strict perspective  including braces in a single line conditional in JavaScript also does not do anything  but it is still a valid practice

User · Answer

SELECT DATABASE   worked in PHPMyAdmin

User · Answer

mysql result mysql query  SELECT DATABASE      0    If no database selected  or there is no connection it returns NULL otherwise the name of the selected database

[mysql] MySQL: determine which database is selected?

Examples related to mysql