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

發(fā)布時間: 2012/7/9 18:21:07

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

可是今兒給大家介紹個好用的命令--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ù)庫時更加方便快捷。

您也可以在在my.cnf配置文件里進行配置：

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.啟動 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)> 本篇文章