mysql 掌握台法式的提醒符 prompt 字符串設置

mysql 掌握台法式的提醒符 prompt 字符串設置。本站提示廣大學習愛好者：（mysql 掌握台法式的提醒符 prompt 字符串設置）文章只能為提供參考，不一定能成為您想要的結果。以下是mysql 掌握台法式的提醒符 prompt 字符串設置正文

---

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

mysql 掌握台法式的默許提醒符為 "mysql>". 該提醒符可用依據須要停止修正設置:

有以下幾種設置方法:

設置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>

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