mysql prompt一個特殊好用的敕令

mysql prompt一個特殊好用的敕令。本站提示廣大學習愛好者：（mysql prompt一個特殊好用的敕令）文章只能為提供參考，不一定能成為您想要的結果。以下是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 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設置裝備擺設文件裡停止設置裝備擺設：

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

這裡也給出須要的一些個選項供年夜家參考。
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