MySql variables
Syntax
--variable-name=value
andbooleanoptions{FALSE|TRUE} |
Value(afterreadingoptions) |
auto-rehash |
TRUE |
character-sets-dir |
(Nodefaultvalue) |
column-type-info |
FALSE |
comments |
FALSE |
compress |
FALSE |
debug-check |
FALSE |
debug-info |
FALSE |
database |
(Nodefaultvalue) |
default-character-set |
latin1 |
delimiter |
; |
vertical |
FALSE |
force |
FALSE |
named-commands |
FALSE |
ignore-spaces |
FALSE |
local-infile |
FALSE |
no-beep |
FALSE |
host |
(Nodefaultvalue) |
html |
FALSE |
xml |
FALSE |
line-numbers |
TRUE |
unbuffered |
FALSE |
column-names |
TRUE |
sigint-ignore |
FALSE |
port |
0 |
prompt |
mysql> |
quick |
FALSE |
raw |
FALSE |
reconnect |
TRUE |
shared-memory-base-name |
(Nodefaultvalue) |
socket |
(Nodefaultvalue) |
ssl |
FALSE |
ssl-ca |
(Nodefaultvalue) |
ssl-capath |
(Nodefaultvalue) |
ssl-cert |
(Nodefaultvalue) |
ssl-cipher |
(Nodefaultvalue) |
ssl-key |
(Nodefaultvalue) |
ssl-verify-server-cert |
FALSE |
table |
FALSE |
user |
(Nodefaultvalue) |
safe-updates |
FALSE |
i-am-a-dummy |
FALSE |
connect_timeout |
0 |
max_allowed_packet |
16777216 |
net_buffer_length |
16384 |
select_limit |
1000 |
max_join_size |
1000000 |
secure-auth |
FALSE |
show-warnings |
FALSE |
Related
MySQL command line
Copyright © 1999-2023
SS64.com
Some rights reserved