源码网商城,靠谱的源码在线交易网站 我的订单 购物车 帮助

源码网商城

mysql 控制台程序的提示符 prompt 字符串设置

  • 时间:2022-11-03 04:05 编辑: 来源: 阅读:
  • 扫一扫,手机访问
摘要:mysql 控制台程序的提示符 prompt 字符串设置
The prompt command reconfigures the default mysql> prompt. The string for defining the prompt can contain the following special sequences. mysql 控制台程序的默认提示符为 "mysql>". 该提示符可用根据需要进行修改设置: [b]有以下几种设置方式: [/b] 设置shell 的环境变量 : MYSQL_PS1 shell> export MYSQL_PS1="(\u@\h) [\d]> " 使用程序启动命令选项 : --prompt shell> mysql --prompt="(\u@\h) [\d]> " (user@host) [database]> 设置选项文件中的 [mysql] 节,添加 prompt 选项 [mysql] prompt=(\\u@\\h) [\\d]>\\_ 在 mysql 程序中使用 prompt (\R) 命令 mysql> prompt (\u@\h) [\d]>\_ PROMPT set to '(\u@\h) [\d]>\_' (user@host) [database]> (user@host) [database]> prompt Returning to default PROMPT of mysql> mysql> [b]prompt 中一些特殊的转义字符串[/b]
Option Description
[code]\c[/code] A counter that increments for each statement you issue
[code]\D[/code] The full current date
[code]\d[/code] [b]The default database[/b]
[code]\h[/code] [b]The server host[/b]
[code]\l[/code] [b]The current delimiter (new in 5.1.12)[/b]
[code]\m[/code] Minutes of the current time
[code]\n[/code] A newline character
[code]\O[/code] The current month in three-letter format (Jan, Feb, …)
[code]\o[/code] The current month in numeric format
[code]\P[/code] am/pm
[code]\p[/code] [b]The current TCP/IP port or socket file[/b]
[code]\R[/code] The current time, in 24-hour military time (0–23)
[code]\r[/code] The current time, standard 12-hour time (1–12)
[code]\S[/code] Semicolon
[code]\s[/code] Seconds of the current time
[code]\t[/code] A tab character
[code]\U[/code] [b]Your full [code][i]user_name[/code][/i]@[i][code]host_name[/code][/i] account name[/b]
[code]\u[/code] [b]Your user name[/b]
[code]\v[/code] The server version
[code]\w[/code] The current day of the week in three-letter format (Mon, Tue, …)
[code]\Y[/code] The current year, four digits
[code]\y[/code] The current year, two digits
[code]\_[/code] A space
[code]\ [/code] A space (a space follows the backslash)
[code]\'[/code] Single quote
[code]\"[/code] Double quote
[code]\\[/code] A literal “[code]\[/code]” backslash character
[code]\[i]x[/code][/i] [i][code]x[/code][/i], for any “[i][code]x[/code][/i]” not listed above
  • 全部评论(0)
联系客服
客服电话:
400-000-3129
微信版

扫一扫进微信版
返回顶部