mysql prompt一個(gè)特別好用的命令

更新時(shí)間：2013年06月13日 08:57:14 作者：

本篇文章是對(duì)mysql中的prompt進(jìn)行了詳細(xì)的分析介紹，需要的朋友參考下

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

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

[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

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;

這樣做的好處就是讓我們大家在操作數(shù)據(jù)庫(kù)時(shí)更加方便快捷。

您也可以在在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

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)>

這里也給出需要的一些個(gè)選項(xiàng)供大家參考。

Option	Description
`\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 full `user_name@host_name` account 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