notes/config/mysql/myclirc

190 lines
7.2 KiB
INI
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

# vi: ft=dosini
[main]
# Enables context sensitive auto-completion. If this is disabled the all
# possible completions will be listed.
smart_completion = True
# Multi-line mode allows breaking up the sql statements into multiple lines. If
# this is set to True, then the end of the statements must have a semi-colon.
# If this is set to False then sql statements can't be split into multiple
# lines. End of line (return) is considered as the end of the statement.
multi_line = True
# Destructive warning mode will alert you before executing a sql statement
# that may cause harm to the database such as "drop table", "drop database"
# or "shutdown".
destructive_warning = True
# log_file location.
log_file = ~/.cache/mycli/mycli.log
# Default log level. Possible values: "CRITICAL", "ERROR", "WARNING", "INFO"
# and "DEBUG". "NONE" disables logging.
log_level = INFO
# Log every query and its results to a file. Enable this by uncommenting the
# line below.
audit_log = ~/.cache/mycli/mycli-audit.log
# Timing of sql statments and table rendering.
timing = True
# Table format. Possible values: ascii, double, github,
# psql, plain, simple, grid, fancy_grid, pipe, orgtbl, rst, mediawiki, html,
# latex, latex_booktabs, textile, moinmoin, jira, vertical, tsv, csv.
# Recommended: ascii
table_format = simple
# Syntax coloring style. Possible values (many support the "-dark" suffix):
# manni, igor, xcode, vim, autumn, vs, rrt, native, perldoc, borland, tango, emacs,
# friendly, monokai, paraiso, colorful, murphy, bw, pastie, paraiso, trac, default,
# fruity.
# Screenshots at http://mycli.net/syntax
# Can be further modified in [colors]
syntax_style = monokai
# Keybindings: Possible values: emacs, vi.
# Emacs mode: Ctrl-A is home, Ctrl-E is end. All emacs keybindings are available in the REPL.
# When Vi mode is enabled you can use modal editing features offered by Vi in the REPL.
key_bindings = emacs
# Enabling this option will show the suggestions in a wider menu. Thus more items are suggested.
wider_completion_menu = True
# MySQL prompt
# \D - The full current date
# \d - Database name
# \h - Hostname of the server
# \m - Minutes of the current time
# \n - Newline
# \P - AM/PM
# \p - Port
# \R - The current time, in 24-hour military time (023)
# \r - The current time, standard 12-hour time (112)
# \s - Seconds of the current time
# \t - Product type (Percona, MySQL, MariaDB)
# \A - DSN alias name (from the [alias_dsn] section)
# \u - Username
# \x1b[...m - insert ANSI escape sequence
# prompt = '\x1b[1;33m[\x1b[1;31m\t \x1b[32m\u\x1b[37m@\x1b[34m\h:\x1b[36m\p\x1b[31m/\d\x1b[1;33m] \x1b[35m➜ '
prompt = '\x1b[37m# \x1b[1;33m\t \x1b[32m\u\x1b[37m@\x1b[34m\h\x1b[37m:\x1b[36m\p\x1b[37m/\x1b[31m\d \x1b[35m➜ '
prompt_continuation = ' '
# \x1b[0m 所有属性重设为默认值,通常出现在一串指令的最后
# \x1b[1m 设置粗体,高亮
# \x1b[2m 设置亮度减半(用一种颜色模拟另一种颜色)
# \x1b[4m 设置下划线,下划线的颜色由”\x1b]…“设置
# \x1b[5m 设置闪烁
# \x1b[7m 设置反显,前景色与背景色交换(字体颜色与背景颜色)
# \x1b[8m 隐藏,前景色与背景色同色
# \x1b[9m 设置删除线(示例效果:谁也逃不过王境泽定律
# \x1b[10m 重设选定映像,显示控制标记,反转元素标记
# \x1b[11m 选择空映像,设置显示控制标记,重设反转标记.
# \x1b[12m 选择空映像,设置显示控制标记,重设反转标记.(在完成映像表转换之前反转标记引起每一字节的高位反转.)
# \x1b[21m 设置正常亮度与ECMA-48 不兼容)
# \x1b[22m 设置正常亮度
# \x1b[24m 关闭下划线
# \x1b[25m 关闭闪烁
# \x1b[27m 关闭反显
# \x1b[28m 关闭影藏
# \x1b[29m 关闭删除线
# \x1b[30-37m 30黑色前景31红色前景32绿色前景33棕色前景34蓝色前景35品红前景36孔雀蓝前景37白色前景
# \x1b[38m 设置RGB前景色
# \x1b[39m 设置默认前景色
# \x1b[40-47m 40:黑色背景41红色背景42绿色背景43棕色背景44蓝色背景45品红背景46孔雀蓝背景47白色背景
# \x1b[48m 设置RGB背景色
# \x1b[53m 设置上划线
# \x1b[55m 关闭上划线
# \x1b[90-97m 设置前景色颜色同30-37亮度提升
# \x1b[100-107m 设置背景色颜色同41-47亮度提升
#
# SGR指令能够在一条指令中添加多个属性例如\x1b[5;9;30;41m 即为设置闪烁,下划线,黑色字体红色背景。
# 在Xterm KDE 的konsole以及支持libvte的终端上支持如下指令
# \x1b[38;2;r;g;bm 选择RGB前景色
# \x1b[48;2;r;g;bm 选择RGB背景色
# Skip intro info on startup and outro info on exit
less_chatty = False
# Use alias from --login-path instead of host name in prompt
login_path_as_host = False
# Cause result sets to be displayed vertically if they are too wide for the current window,
# and using normal tabular format otherwise. (This applies to statements terminated by ; or \G.)
auto_vertical_output = False
# keyword casing preference. Possible values "lower", "upper", "auto"
keyword_casing = auto
# disabled pager on startup
enable_pager = False
# Custom colors for the completion menu, toolbar, etc.
[colors]
completion-menu.completion.current = 'bg:#ffffff #000000'
completion-menu.completion = 'bg:#008888 #ffffff'
completion-menu.meta.completion.current = 'bg:#44aaaa #000000'
completion-menu.meta.completion = 'bg:#448888 #ffffff'
completion-menu.multi-column-meta = 'bg:#aaffff #000000'
scrollbar.arrow = 'bg:#003333'
scrollbar = 'bg:#00aaaa'
selected = '#ffffff bg:#6666aa'
search = '#ffffff bg:#4444aa'
search.current = '#ffffff bg:#44aa44'
bottom-toolbar = 'bg:#222222 #aaaaaa'
bottom-toolbar.off = 'bg:#222222 #888888'
bottom-toolbar.on = 'bg:#222222 #ffffff'
search-toolbar = 'noinherit bold'
search-toolbar.text = 'nobold'
system-toolbar = 'noinherit bold'
arg-toolbar = 'noinherit bold'
arg-toolbar.text = 'nobold'
bottom-toolbar.transaction.valid = 'bg:#222222 #00ff5f bold'
bottom-toolbar.transaction.failed = 'bg:#222222 #ff005f bold'
# style classes for colored table output
output.header = "#00ff5f bold"
output.odd-row = ""
output.even-row = ""
output.null = "#808080"
# SQL syntax highlighting overrides
sql.comment = 'italic #408080'
# sql.comment.multi-line = ''
# sql.comment.single-line = ''
# sql.comment.optimizer-hint = ''
# sql.escape = 'border:#FF0000'
# sql.keyword = 'bold #008000'
# sql.datatype = 'nobold #B00040'
# sql.literal = ''
# sql.literal.date = ''
# sql.symbol = ''
# sql.quoted-schema-object = ''
# sql.quoted-schema-object.escape = ''
# sql.constant = '#880000'
# sql.function = '#0000FF'
# sql.variable = '#19177C'
# sql.number = '#666666'
# sql.number.binary = ''
# sql.number.float = ''
# sql.number.hex = ''
# sql.number.integer = ''
# sql.operator = '#666666'
# sql.punctuation = ''
# sql.string = '#BA2121'
# sql.string.double-quouted = ''
# sql.string.escape = 'bold #BB6622'
# sql.string.single-quoted = ''
# sql.whitespace = ''
# Favorite queries.
[favorite_queries]
# Use the -d option to reference a DSN.
# Special characters in passwords and other strings can be escaped with URL encoding.
[alias_dsn]
# example_dsn = mysql://[user[:password]@][host][:port][/dbname]
local = mysql://admin@127.0.0.1:3306/test