my.cnf 参数说明

最新推荐文章于 2022-08-08 16:32:00 发布

转载最新推荐文章于 2022-08-08 16:32:00 发布 · 109 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/djinmusic/p/4177202.html

文章标签：

#数据库 #网络

本文详细介绍了如何在MySQL中自定义命令行提示符，通过使用特定的字符串序列，如u用户名称、h主机名、d默认数据库等，可以创建个性化的提示符，增强数据库操作的便利性和直观性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[mysql]

prompt="\\u@\\h:\p \\R:\\m:\\s [\\d]>"

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

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

来自为知笔记(Wiz)

转载于:https://www.cnblogs.com/djinmusic/p/4177202.html