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

復(fù)制代碼 代碼如下:

[root@fsailing1 ~]# mysql -uroot -p --prompt="http://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配置文件里進(jìn)行配置：

復(fù)制代碼 代碼如下:

[mysql]
prompt=mysql(//u@//h://d)>

default-character-set=utf8

復(fù)制代碼 代碼如下:

[root@fsailing1 ~]# vim /etc/my.cnf
[root@fsailing1 ~]# service mysqld restart
停止 MySQL：[確定]
啟動(dòng) 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)>

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