mysql 控制臺程序的提示符 prompt 字符串設置

更新時間：2011年08月07日 11:37:47 作者：

mysql 控制臺程序的提示符 prompt 字符串設置，學習mysql的朋友可以參考下。

The prompt command reconfigures the default mysql> prompt. The string for defining the prompt can contain the following special sequences.

mysql 控制臺程序的默認提示符為 "mysql>". 該提示符可用根據(jù)需要進行修改設置:

有以下幾種設置方式:

設置shell 的環(huán)境變量 : MYSQL_PS1

shell> export MYSQL_PS1="(\u@\h) [\d]> "

使用程序啟動命令選項 : --prompt

shell> mysql --prompt="(\u@\h) [\d]> "
(user@host) [database]>

設置選項文件中的 [mysql] 節(jié),添加 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 中一些特殊的轉(zhuǎn)義字符串

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