想必大家在命令行操作mysql的时候会十分发愁现在的操作的是那个数据库吧，至少我就纠结过，可能您会说我打一条命令不就知道了，是的这样做确实可以的。
可是今儿给大家介绍个好用的命令--prompt
复制代码 代码如下:
[root@fsailing1 ~]# 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 378
Server version: 5.0.95 Source distribution
Copyright (c) 2000, 2011, 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) 08:23:32>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 08:23:44>exit;
这样做的好处就是让我们大家在操作数据库时更加方便快捷。
您也可以在在my.cnf配置文件里进行配置：
复制代码 代码如下:
[mysql]
prompt=mysql(u@h:d)>
default-character-set=utf8
复制代码 代码如下:
[root@fsailing1 ~]# vim /etc/my.cnf
[root@fsailing1 ~]# service mysqld restart
停止 MySQL： [确定]
启动 MySQL： [确定]
[root@fsailing1 ~]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 2
Server version: 5.0.95 Source distribution
Copyright (c) 2000, 2011, 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(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
mysql(root@localhost:test)>
这里也给出需要的一些个选项供大家参考。
| 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 fulluser_name@host_nameaccount 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 |
【mysql prompt一个特别好用的命令】相关文章：
★ mysql 终结点映射器中没有更多的终结点可用的解决方法