SHOW VARIABLES

Giriş

Söz dizimi şöyle

SHOW [GLOBAL | SESSION] VARIABLES
    [LIKE 'pattern' | WHERE expr]

Açıklaması şöyle

To assign a value to a global system variable, precede the variable name by the GLOBAL
keyword or the @@GLOBAL. qualifier:

SET GLOBAL max_connections = 1000;
SET @@GLOBAL.max_connections = 1000;

To assign a value to a session system variable, precede the variable name by the SESSION 
or LOCAL keyword, by the @@SESSION., @@LOCAL., or @@ qualifier, or by no keyword or 
no modifier at all:

SET SESSION sql_mode = 'TRADITIONAL';
SET LOCAL sql_mode = 'TRADITIONAL';
SET @@SESSION.sql_mode = 'TRADITIONAL';
SET @@LOCAL.sql_mode = 'TRADITIONAL';
SET @@sql_mode = 'TRADITIONAL';
SET sql_mode = 'TRADITIONAL';

VARIABLES

Örnek

Şöyle yaparız

SHOW VARIABLES LIKE '%...%';

Örnek

Binary Logs yazısına taşıdım

GLOBAL VARIABLES

Örnek

Şöyle yaparız

SHOW GLOBAL VARIABLES;