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

2021年12月8日 08:47:49数据库评论557字数 1349阅读模式

mysql 控制台程序的提示符 prompt 字符串设置，学习mysql的朋友可以参考下。

The prompt command reconfigures the default mysql> prompt. The string for defining the prompt can contain the following special sequences.文章源自很文博客https://www.hinwi.com/很文博客-https://www.hinwi.com/11943.html

mysql 控制台程序的默认提示符为 "mysql>". 该提示符可用根据需要进行修改设置:文章源自很文博客https://www.hinwi.com/很文博客-https://www.hinwi.com/11943.html

有以下几种设置方式:文章源自很文博客https://www.hinwi.com/很文博客-https://www.hinwi.com/11943.html

设置shell 的环境变量 : MYSQL_PS1文章源自很文博客https://www.hinwi.com/很文博客-https://www.hinwi.com/11943.html

shell> export MYSQL_PS1="(\u@\h) [\d]> "文章源自很文博客https://www.hinwi.com/很文博客-https://www.hinwi.com/11943.html

使用程序启动命令选项 : --prompt文章源自很文博客https://www.hinwi.com/很文博客-https://www.hinwi.com/11943.html

shell> mysql --prompt="(\u@\h) [\d]> "文章源自很文博客https://www.hinwi.com/很文博客-https://www.hinwi.com/11943.html

(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>

prompt 中一些特殊的转义字符串

Option	Description
`\c`	A counter that increments for each statement you issue
`\D`	The full current date
`\d`	The default database
`\h`	The server host
`\l`	The current delimiter (new in 5.1.12)
`\m`	Minutes of the current time
`\n`	A newline character
`\O`	The current month in three-letter format (Jan, Feb, …)
`\o`	The current month in numeric format
`\P`	am/pm
`\p`	The current TCP/IP port or socket file
`\R`	The current time, in 24-hour military time (0–23)
`\r`	The current time, standard 12-hour time (1–12)
`\S`	Semicolon
`\s`	Seconds of the current time
`\t`	A tab character
`\U`	Your full `user_name@host_name` account name
`\u`	Your user name
`\v`	The server version
`\w`	The current day of the week in three-letter format (Mon, Tue, …)
`\Y`	The current year, four digits
`\y`	The current year, two digits
`\_`	A space
`\`	A space (a space follows the backslash)
`\'`	Single quote
`\"`	Double quote
`\\`	A literal “`\`” backslash character
`\x`	`x`, for any “`x`” not listed above