mysql - 是否可以在 MySQL "show variables"中仅显示值？

Question

查找 MySQL 变量值很容易:

mysql> show variables where Variable_name = 'version';+---------------+--------------------+| Variable_name | Value              |+---------------+--------------------+| version       | 5.0.19-Max         |+---------------+--------------------+1 row in set (0.00 sec)

但是是否有任何语法允许只选择具有变量值的列，如下所示:

mysql> command_i_want_to_know+--------------------+| Value              |+--------------------+| 5.0.19-Max         |+--------------------+1 row in set (0.00 sec)

Answer 1

还有一个变种 -

SELECT @@version;