mysql --prompt一個(gè)很好用的命令

想必大家在命令行操作mysql的時(shí)候會(huì)十分發(fā)愁現(xiàn)在的操作的是那個(gè)數(shù)據(jù)庫(kù)吧，至少我就糾結(jié)過(guò)，可能您會(huì)說(shuō)我打一條命令不就知道了，是的這樣做確實(shí)可以的。

可是今兒給大家介紹個(gè)好用的命令--prompt

1.[root@ www.linuxidc.com ~]# mysql -uroot -p --prompt="\\u@\\h:\\d \\r:\\m:\\s>" 
2.Enter password: 
3.Welcome to the MySQL monitor.  Commands end with ; or \g. 
4.Your MySQL connection id is 378 
5.Server version: 5.0.95 Source distribution 
6. 
7.Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. 
8. 
9.Oracle is a registered trademark of Oracle Corporation and/or its 
10.affiliates. Other names may be trademarks of their respective 
11.owners. 
12. 
13.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 
14. 
15.root@localhost:(none) 08:23:32>use test;  16.Reading table information for completion of table and column names 
17.You can turn off this feature to get a quicker startup with -A 
18. 
19.Database changed 
20.root@localhost:test 08:23:44>exit;  這樣做的好處就是讓我們大家在操作數(shù)據(jù)庫(kù)時(shí)更加方便快捷。

您也可以在在my.cnf配置文件里進(jìn)行配置：

1.[mysql] 
2.prompt=mysql(\\u@\\h:\\d)>  3. 
4.default-character-set=utf8 
 
1.[root@ www.linuxidc.com ~]# vim /etc/my.cnf 
2.[root@ www.linuxidc.com ~]# service mysqld restart 
3.停止 MySQL：                                               [確定] 
4.啟動(dòng) MySQL：                                               [確定] 
5.[root@ www.linuxidc.com ~]# mysql -uroot -p 
6.Enter password: 
7.Welcome to the MySQL monitor.  Commands end with ; or \g. 
8.Your MySQL connection id is 2 
9.Server version: 5.0.95 Source distribution 
10. 
11.Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved. 
12. 
13.Oracle is a registered trademark of Oracle Corporation and/or its 
14.affiliates. Other names may be trademarks of their respective 
15.owners. 
16. 
17.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. 
18. 
19.mysql(root@localhost:(none))>use test;  20.Reading table information for completion of table and column names 
21.You can turn off this feature to get a quicker startup with -A 
22. 
23.Database changed 
24.mysql(root@localhost:test)>  本篇文章
 

服務(wù)器租用/服務(wù)器托管中國(guó)五強(qiáng)！虛擬主機(jī)域名注冊(cè)頂級(jí)提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]