个性化设置MySQL prompt提示符
下面谈 4 种方法
㈠ 在 Bash 层修改 MYSQL_PS1 变量
[plain]
[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 命令行参数
[plain]
[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
[plain]
[mysql]
prompt=(\u@\h) [\d]>\_
又或者:
[mysql]
prompt="\r:\m:\s> "
要多加一个反斜线.
㈣ 在 MySQL 中使用 prompt 命令
[sql]
mysql> prompt r:m:sP>_
PROMPT set to 'r:m:sP>_'
08:20:42pm> prompt
Returning to default PROMPT of mysql>
mysql>
附录:
[plain]
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
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