MariaDB 10.6でバージョンを確認する方法

環境
Windows 10 64bit
MariaDB 10.6

方法1
以下のコマンドでバージョンを確認します

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
MariaDB [(none)]> select version();
+----------------+
| version() |
+----------------+
| 10.6.4-MariaDB |
+----------------+
1 row in set (0.000 sec)
MariaDB [(none)]> select version(); +----------------+ | version() | +----------------+ | 10.6.4-MariaDB | +----------------+ 1 row in set (0.000 sec)
MariaDB [(none)]> select version();
+----------------+
| version()      |
+----------------+
| 10.6.4-MariaDB |
+----------------+
1 row in set (0.000 sec)

方法2

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
MariaDB [(none)]> status
--------------
mysql Ver 15.1 Distrib 10.6.4-MariaDB, for Win64 (AMD64), source revision 2db692f5b4d6bb31a331dab44544171c455f6aca
Connection id: 3
Current database:
Current user: root@localhost
SSL: Not in use
Using delimiter: ;
Server: MariaDB
Server version: 10.6.4-MariaDB mariadb.org binary distribution
Protocol version: 10
Connection: localhost via TCP/IP
Server characterset: utf8mb4
Db characterset: utf8mb4
Client characterset: utf8mb3
Conn. characterset: utf8mb3
TCP port: 13306
Uptime: 1 day 16 hours 4 sec
Threads: 1 Questions: 7 Slow queries: 0 Opens: 145 Open tables: 138 Queries per second avg: 0.000
MariaDB [(none)]> status -------------- mysql Ver 15.1 Distrib 10.6.4-MariaDB, for Win64 (AMD64), source revision 2db692f5b4d6bb31a331dab44544171c455f6aca Connection id: 3 Current database: Current user: root@localhost SSL: Not in use Using delimiter: ; Server: MariaDB Server version: 10.6.4-MariaDB mariadb.org binary distribution Protocol version: 10 Connection: localhost via TCP/IP Server characterset: utf8mb4 Db characterset: utf8mb4 Client characterset: utf8mb3 Conn. characterset: utf8mb3 TCP port: 13306 Uptime: 1 day 16 hours 4 sec Threads: 1 Questions: 7 Slow queries: 0 Opens: 145 Open tables: 138 Queries per second avg: 0.000
MariaDB [(none)]> status
--------------
mysql  Ver 15.1 Distrib 10.6.4-MariaDB, for Win64 (AMD64), source revision 2db692f5b4d6bb31a331dab44544171c455f6aca

Connection id:          3
Current database:
Current user:           root@localhost
SSL:                    Not in use
Using delimiter:        ;
Server:                 MariaDB
Server version:         10.6.4-MariaDB mariadb.org binary distribution
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    utf8mb4
Db     characterset:    utf8mb4
Client characterset:    utf8mb3
Conn.  characterset:    utf8mb3
TCP port:               13306
Uptime:                 1 day 16 hours 4 sec

Threads: 1  Questions: 7  Slow queries: 0  Opens: 145  Open tables: 138  Queries per second avg: 0.000

方法3

Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
>mysql --version
mysql Ver 15.1 Distrib 10.6.4-MariaDB, for Win64 (AMD64), source revision 2db692f5b4d6bb31a331dab44544171c455f6aca
>mysql --version mysql Ver 15.1 Distrib 10.6.4-MariaDB, for Win64 (AMD64), source revision 2db692f5b4d6bb31a331dab44544171c455f6aca
>mysql --version
mysql  Ver 15.1 Distrib 10.6.4-MariaDB, for Win64 (AMD64), source revision 2db692f5b4d6bb31a331dab44544171c455f6aca

 

MariaDB

Posted by arkgame