MariaDB 10.6.4で現在使っているデータベース名を表示する
環境
MariaDB 10.6.4
1.使いたいデータベースに接続します
MariaDB [(none)]> use testdb
Database changed
MariaDB [(none)]> use testdb
Database changed
MariaDB [(none)]> use testdb Database changed
2.現在利用しているデータベースを確認します
MariaDB [testdb]> SELECT database();
+------------+
| database() |
+------------+
| testdb |
+------------+
1 row in set (0.001 sec)
MariaDB [testdb]> SELECT database();
+------------+
| database() |
+------------+
| testdb |
+------------+
1 row in set (0.001 sec)
MariaDB [testdb]> SELECT database(); +------------+ | database() | +------------+ | testdb | +------------+ 1 row in set (0.001 sec)
3.接続中のデータベースを表示します
MariaDB [testdb]> SHOW PROCESSLIST;
+----+------+-----------------+--------+---------+------+----------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+----+------+-----------------+--------+---------+------+----------+------------------+----------+
| 6 | root | localhost:62351 | testdb | Query | 0 | starting | SHOW PROCESSLIST | 0.000 |
+----+------+-----------------+--------+---------+------+----------+------------------+----------+
1 row in set (0.016 sec)
MariaDB [testdb]> SHOW PROCESSLIST;
+----+------+-----------------+--------+---------+------+----------+------------------+----------+
| Id | User | Host | db | Command | Time | State | Info | Progress |
+----+------+-----------------+--------+---------+------+----------+------------------+----------+
| 6 | root | localhost:62351 | testdb | Query | 0 | starting | SHOW PROCESSLIST | 0.000 |
+----+------+-----------------+--------+---------+------+----------+------------------+----------+
1 row in set (0.016 sec)
MariaDB [testdb]> SHOW PROCESSLIST; +----+------+-----------------+--------+---------+------+----------+------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +----+------+-----------------+--------+---------+------+----------+------------------+----------+ | 6 | root | localhost:62351 | testdb | Query | 0 | starting | SHOW PROCESSLIST | 0.000 | +----+------+-----------------+--------+---------+------+----------+------------------+----------+ 1 row in set (0.016 sec)