揮発性のメモ2

最近知った知識を さも昔から知ってた風にメモ書きしていく

MySQLで、サーバのバージョンをみる

MariaDBの場合

MariaDB [mysql]> SHOW VARIABLES LIKE 'version_comment';
+-----------------+----------------+
| Variable_name   | Value          |
+-----------------+----------------+
| version_comment | MariaDB Server |
+-----------------+----------------+

MariaDB [mysql]> select version();
+-----------------+
| version()       |
+-----------------+
| 10.5.29-MariaDB |
+-----------------+

AWS Auroraの場合

MySQL [hoge]> select version();
+-----------+
| version() |
+-----------+
| 8.0.28    |
+-----------+

MySQL [hoge]> SHOW VARIABLES LIKE 'aurora_version';
+----------------+--------+
| Variable_name  | Value  |
+----------------+--------+
| aurora_version | 3.04.3 |
+----------------+--------+

MySQL [hoge]> SELECT AURORA_VERSION();
+------------------+
| AURORA_VERSION() |
+------------------+
| 3.04.3           |
+------------------+