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