| 1 |
SELECT @@version; |
| 2 |
@@version |
| 3 |
my_favorite_version |
| 4 |
1 |
| 5 |
select * from information_schema.system_variables where variable_name='version'; |
| 6 |
VARIABLE_NAME VERSION |
| 7 |
SESSION_VALUE NULL |
| 8 |
GLOBAL_VALUE my_favorite_version |
| 9 |
GLOBAL_VALUE_ORIGIN COMMAND-LINE |
| 10 |
DEFAULT_VALUE NULL |
| 11 |
VARIABLE_SCOPE GLOBAL |
| 12 |
VARIABLE_TYPE VARCHAR |
| 13 |
VARIABLE_COMMENT Server version number. It may also include a suffix with configuration or build information. -debug indicates debugging support was enabled on the server, and -log indicates at least one of the binary log, general log or slow query log are enabled, for example 10.1.1-MariaDB-mariadb1precise-log |
| 14 |
NUMERIC_MIN_VALUE NULL |
| 15 |
NUMERIC_MAX_VALUE NULL |
| 16 |
NUMERIC_BLOCK_SIZE NULL |
| 17 |
ENUM_VALUE_LIST NULL |
| 18 |
READ_ONLY YES |
| 19 |
COMMAND_LINE_ARGUMENT NULL |
| 20 |
GLOBAL_VALUE_PATH NULL |