Is it possible to show only value in MySQL "show variables"?

Question

It is an easy task to find MySQL variable values:

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

But is there any syntax that allows to select only column with variable value, like so:

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

Devart · Accepted Answer · 2011-11-08 07:34:20Z

35

One more variant -

SELECT @@version;

answered Nov 8, 2011 at 7:34

Devart

120k23 gold badges172 silver badges189 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jim H. · Accepted Answer · 2011-11-08 05:38:03Z

10

select variable_value 
from information_schema.global_variables
where variable_name = 'version';

answered Nov 8, 2011 at 5:38

Jim H.

5,5591 gold badge26 silver badges23 bronze badges

2 Comments

bessarabov Over a year ago

As written in the manual "The GLOBAL_VARIABLES and SESSION_VARIABLES tables were added in MySQL 5.1.12." So this does not work in 5.0 dev.mysql.com/doc/refman/5.1/en/variables-table.html

Abbas Uddin Over a year ago

That's the way for 5.5 users, BTW my problem solved by @Devart.

Luis Talora · Accepted Answer · 2023-04-18 19:20:31Z

0

Complementing previous answers: depending on your MySQL version and settings, you will probably need this to make it work:

set @@global.show_compatibility_56=1;

You may also want to add this to your my.cnf, under the [mysqld] section:

show_compatibility_56 = 1

answered Apr 18, 2023 at 19:20

Luis Talora

1105 bronze badges

Collectives™ on Stack Overflow

Is it possible to show only value in MySQL "show variables"?

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related