个性化设置 MySQL prompt 提示符-mysql教程-PHP中文网

个性化设置 MySQL prompt 提示符

php中文网

发布： 2016-06-07 15:08:37

原创

1788人浏览过

下面谈 4 种方法㈠在 Bash 层修改 MYSQL_PS1 变量 [root@localhost ~]# export MYSQL_PS1=(u@h) [d] [root@localhost ~]# mysql -u root -pEnter password: Welcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 73S

下面谈 4 种方法

㈠在 bash 层修改 mysql_ps1 变量

富兰氏手机商城系统源码 2011

全国首个为手机行业定制的网站，外观豪华、时尚。DIV+CSS构建，符合W3C标准，完美搜索引擎优化迅速提高搜索引擎排名，稳定性、执行效率、负载能力均居国内同类产品领先地位。安装简单，傻瓜式操作，在线下单、支付、发货，轻松管理网站。多套模板更换，界面更加豪华完美搜索引擎优化集成支付宝、财付通、网银等多种在线支付平台手机、配件商品不同颜色、型号不同价格设置图片化多种参数设置、搜索、评论新闻

查看详情

[root@localhost ~]# export MYSQL_PS1="(u@h) [d]> "
[root@localhost ~]# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 73
Server version: 5.5.28 MySQL Community Server (GPL)

Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

(root@localhost) [(none)]> use test;
Database changed
(root@localhost) [test]>

登录后复制

㈡ MySQL 命令行参数

[root@localhost ~]# mysql -u root -p --prompt="(u@h) [d]> "
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 74
Server version: 5.5.28 MySQL Community Server (GPL)

Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

(root@localhost) [(none)]>

登录后复制

㈢配置文件 /etc/my.cnf

[mysql]
prompt=(\u@\h) [\d]>\_
 
又或者：
[mysql]
prompt="\r:\m:\s> "

要多加一个反斜线.

登录后复制

㈣在 MySQL 中使用 prompt 命令

mysql> prompt 
:m:sP>_
PROMPT set to '
:m:sP>_'
08:20:42pm> prompt
Returning to default PROMPT of mysql> 
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.0.25)
m	Minutes of the current time

	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)

	The current time, standard 12-hour time (1–12)
S	Semicolon
s	Seconds of the current time
		A tab character
U	
Your full user_name@host_name account name
 
u	Your user name
	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

登录后复制