个性化设置 MySQL prompt 提示符
来源:互联网 发布:宜家值得买 知乎 编辑:程序博客网 时间:2024/06/05 21:51
下面谈 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 73Server 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 itsaffiliates. Other names may be trademarks of their respectiveowners.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 74Server 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 itsaffiliates. Other names may be trademarks of their respectiveowners.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 \r:\m:\s\P>\_PROMPT set to '\r:\m:\s\P>\_'08:20:42pm> promptReturning to default PROMPT of mysql> mysql>
附录:
OptionDescription\cA counter that increments for each statement you issue\DThe full current date\dThe default database\hThe server host\lThe current delimiter (new in 5.0.25)\mMinutes of the current time\nA newline character\OThe current month in three-letter format (Jan, Feb, …)\oThe current month in numeric format\Pam/pm\pThe current TCP/IP port or socket file\RThe current time, in 24-hour military time (0–23)\rThe current time, standard 12-hour time (1–12)\SSemicolon\sSeconds of the current time\tA tab character\UYour full user_name@host_name account name \uYour user name\vThe server version\wThe current day of the week in three-letter format (Mon, Tue, …)\YThe current year, four digits\yThe current year, two digits\_A space\ A space (a space follows the backslash)\'Single quote\"Double quote\\A literal “\” backslash character\xx, for any “x” not listed above
- 个性化设置 MySQL prompt 提示符
- MySql 个性化设置提示符
- Prompt设置提示符
- mysql提示符命令prompt
- 巧用mysql提示符prompt清晰管理数据库
- 命令提示符:prompt
- Linux 命令提示符个性化
- Bash Prompt -Linux 终端提示符
- prompt设置
- mysql prompt
- 个性化你的shell提示符
- 进击的Geek(二):Ubuntu16.04命令行提示符颜色的个性化设置
- Linux/Unix中的命令提示符prompt
- Linux/Unix中的命令提示符prompt
- Linux/Unix中的命令提示符prompt
- 自定义bash提示符 -- Bash prompt basics
- zsh 自定义命令提示符(PS1/ prompt)
- shell提示符的个性化设定(一)
- android下SQLite学习笔记
- 冒泡排序、插入排序、选择排序--C语言实现
- Bash游戏 V3
- 数据结构复习笔记(一)
- hdu 1548 最短路
- 个性化设置 MySQL prompt 提示符
- A* (路径搜索)算法导引
- 软件测试DAY02
- MySql存储过程—1、SQL存储过程的基础知识
- 单点登录技术Cookie问题
- nc另类应用:内网linux机器A(定时)访问家里无线路由下的机器B
- html5视频播放
- DBCP数据源下载和配置
- [MTK FP]用Python提取模拟器文件