mysql -prompt选项
2024-10-19 06:23:29
使用-pormpt修改提示符。可以在登录时或者在登录后使用prompt选项来修改提示符
(1)使用mysql命令行参数修改提示符
# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 27
Server version: 5.6.25 Source distribution Copyright (c) 2000, 2015, 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. mysql> # mysql -uroot -p --prompt="\\u@\\h:\\d \\r:\\m:\\s>"
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 28
Server version: 5.6.25 Source distribution Copyright (c) 2000, 2015, 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) 10:05:25>use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A Database changed
root@localhost:test 10:05:31>
(2)修改配置文件/etc/my.cnf
[mysql]
prompt="\\u@\\h:\\d \\r:\\m:\\s>"
(3)在 MySQL 中使用 prompt 命令
mysql> prompt \r:\m:\s\P>\_
PROMPT set to \'\r:\m:\s\P>\_\'
08:20:42pm> prompt
Returning to default PROMPT of mysql>
mysql>
(4)当然可以在在Bash层修改 MYSQL_PS1变量
# export MYSQL_PS1="(\u@\h) [\d]> "
# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 31
Server version: 5.6.25 Source distribution Copyright (c) 2000, 2015, 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
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A Database changed
(root@localhost) [test]>
参数辅助说明
| 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 |
\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 |
\ |
|
最新文章
- 如何同时运行两个tomcat？
- 阿里云服务器Linux CentOS安装配置（一）购买阿里云服务器
- 粗略了解struts2
- 解决MD5问题
- JSP中的指令（Directive）
- windows socket网络编程基础知识
- Codeforces Round #FF (Div. 2)
- 388A Fox and Box Accumulation
- 混合使用Azure LB和ILB访问相同web服务（3）
- Angular ng-repeat 对象和数组遍历
- 基于visual Studio2013解决C语言竞赛题之0203格式化输出
- Web测试基于实际测试的功能测试点总结--转载
- 通过intent启动Activity
- Windows下的OpenCVSharp配置
- JAVA8 in Action：行为参数化，匿名类及lambda表达式的初步认知实例整理
- JMeter实现Oracle参数化（1）
- jmeter --- 监控器 Plugins (&jconsole)
- (转)微信小程序开发—弹出框
- java设计模式-----22、状态模式
- 分类问题中的“维数灾难” - robotMax