How do you check which db I am using?

Question

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 .MySQL show current connection info - Stack OverflowMysql how to find current database, assign it into a string variableFind out current database name - sql server - Stack OverflowHow to determine which MySQL database has been selected?Другие результаты с сайта stackoverflow.com

How do you know which DB we are using?

mysql> use test Database changed mysql> SELECT DATABASE() FROM DUAL; The following is the output. mysql> show databases; Here is the output that displays all the databases.

What is my current database name?

The following query gives the name of the database and the server name:1Select * from sysservers.2Select @@servername as [ServerName]3SELECT DB_NAME() AS [Current Database]4Select * from sysdatabases.Getting the Name of the Server and Databases in SQL Server

How do I know MySQL database?

To list all databases on a MySQL server host, you use the SHOW DATABASES command as follows:1SHOW DATABASES; ... 2>mysql -u root -p Enter password: ********** mysql>MySQL SHOW DATABASES: List All Databases in MySQL

How can I tell what is using MySQL?

Type in MYSQL to get into the mysql command line. Type show processlist; in order to see current processes on the server.

Expert · Answer