《MysqL数据库MysqL 控制台程序的提示符 prompt 字符串设置》要点:
本文介绍了MysqL数据库MysqL 控制台程序的提示符 prompt 字符串设置,希望对您有用。如果有疑问,可以联系我们。
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 中一些特殊的转义字符串MysqL必读
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 (0C23) | ||
\r | \S | Semicolon | |
\s | Seconds of the current time | ||
\t | A tab character | ||
\U | Your full | ||
\u | Your user name | ||
\v | The server version | ||
\w | The current day of the week in three-letter format (Mon,Tue,monospace; BACKGROUND-color: white; border-RIGHT-WIDTH: 0px; outline-wIDth: 0px; outline-style: initial; outline-color: initial; background-origin: initial; background-clip: initial">\Y | The current year,four digits | |
\y | \_ | A space | |
\ | A space (a space follows the backslash) | ||
\' | Single quote | ||
\" | Double quote | ||
\\ | A literal “\ ” backslash character | ||
\x | x ,for any “x ” not Listed aboveMysqL必读 |
以上是内存溢出为你收集整理的MYSQL数据库mysql 控制台程序的提示符 prompt 字符串设置全部内容,希望文章能够帮你解决MYSQL数据库mysql 控制台程序的提示符 prompt 字符串设置所遇到的程序开发问题。
如果觉得内存溢出网站内容还不错,欢迎将内存溢出网站推荐给程序员好友。
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)