我的书签
添加书签
移除书签SHOW VARIABLES
Description
SHOW VARIABLES shows the values of MatrixOne system variables.
Syntax
> SHOW VARIABLES[LIKE 'pattern']
Explanations
With a LIKE clause, the statement displays only rows for those variables with names that match the pattern.
To get a list of variables whose name match a pattern, use the % wildcard character in a LIKE clause.
Examples
mysql> SHOW VARIABLES;+--------------------------+-----------------------------------------------------------------------------------------------------------------------+| Variable_name | Value |+--------------------------+-----------------------------------------------------------------------------------------------------------------------+| auto_increment_increment | 1 || auto_increment_offset | 1 || autocommit | 1 || character_set_client | utf8mb4 || character_set_connection | utf8mb4 || character_set_database | utf8mb4 || character_set_results | utf8mb4 || character_set_server | utf8mb4 || collation_connection | default || collation_server | utf8mb4_bin || completion_type | NO_CHAIN || host | 0.0.0.0 || init_connect | || interactive_timeout | 28800 || license | APACHE || lower_case_table_names | 0 || max_allowed_packet | 16777216 || net_write_timeout | 60 || performance_schema | 0 || port | 6001 || profiling | 0 || query_result_maxsize | 100 || query_result_timeout | 24 || save_query_result | 0 || sql_mode | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION || sql_safe_updates | 0 || sql_select_limit | 18446744073709551615 || system_time_zone | || testbotchvar_nodyn | 0 || testbothvar_dyn | 0 || testglobalvar_dyn | 0 || testglobalvar_nodyn | 0 || testsessionvar_dyn | 0 || testsessionvar_nodyn | 0 || time_zone | SYSTEM || transaction_isolation | REPEATABLE-READ || transaction_read_only | 0 || tx_isolation | REPEATABLE-READ || tx_read_only | 0 || version_comment | MatrixOne || wait_timeout | 28800 |+--------------------------+-----------------------------------------------------------------------------------------------------------------------+41 rows in set (0.01 sec)mysql> show variables like 'auto%';+--------------------------+-------+| Variable_name | Value |+--------------------------+-------+| auto_increment_increment | 1 || auto_increment_offset | 1 || autocommit | 1 |+--------------------------+-------+3 rows in set (0.00 sec)mysql> show variables like 'auto_increment_increment';+--------------------------+-------+| Variable_name | Value |+--------------------------+-------+| auto_increment_increment | 1 |+--------------------------+-------+1 row in set (0.00 sec)
