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 | +------------------+