mysql --prompt一个很好用的命令

想必大家在命令行操作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 378Server version: 5.0.95 Source distributionCopyright (c) 2000, 2011, 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) 08:23:32>use test;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedroot@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 -pEnter password:Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 2Server version: 5.0.95 Source distributionCopyright (c) 2000, 2011, 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.mysql(root@localhost:(none))>use test;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql(root@localhost:test)>

这里也给出需要的一些个选项供大家参考。
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.1.12)\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\U

Your 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\x

x, for any “x” not listed above