mysql prompt的用法詳解
更新時(shí)間：2013年06月13日 08:51:42 作者：
本篇文章是對(duì)mysql中prompt的用法進(jìn)行了詳細(xì)的分析介紹，需要的朋友參考下
prompt命令可以在mysql提示符中顯示當(dāng)前用戶(hù)、數(shù)據(jù)庫(kù)、時(shí)間等信息
mysql -uroot -p --prompt="\\u@\\h:\\d \\r:\\m:\\s>"
設(shè)置成功后：
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.1.60-log Source distribution
Copyright (c) 2000, 2012, 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) 11:04:23>
也可以在在my.cnf配置文件里進(jìn)行配置：
[mysql]
prompt=mysql(\\u@\\h:\\d)>
default-character-set=utf8
選項(xiàng)說(shuō)明:
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 www.dbjr.com.cn
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
復(fù)制代碼 代碼如下:
mysql -uroot -p --prompt="\\u@\\h:\\d \\r:\\m:\\s>"
設(shè)置成功后：
復(fù)制代碼 代碼如下:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.1.60-log Source distribution
Copyright (c) 2000, 2012, 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) 11:04:23>
也可以在在my.cnf配置文件里進(jìn)行配置：
復(fù)制代碼 代碼如下:
[mysql]
prompt=mysql(\\u@\\h:\\d)>
default-character-set=utf8
選項(xiàng)說(shuō)明:
復(fù)制代碼 代碼如下:
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 www.dbjr.com.cn
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
相關(guān)文章
這篇文章主要為大家詳細(xì)介紹了MySQL 視圖的基礎(chǔ)操作，告訴大家為什么使用視圖？如何創(chuàng)建視圖等問(wèn)題，感興趣的小伙伴們可以參考一下2016-08-08
mysql中獲取一天、一周、一月時(shí)間數(shù)據(jù)的各種sql語(yǔ)句寫(xiě)法
今天抽時(shí)間整理了一篇mysql中與天、周、月有關(guān)的時(shí)間數(shù)據(jù)的sql語(yǔ)句的各種寫(xiě)法，部分是收集資料，全部手工整理，自己學(xué)習(xí)的同時(shí)，分享給大家，并首先默認(rèn)創(chuàng)建一個(gè)表、插入2條數(shù)據(jù)，便于部分?jǐn)?shù)據(jù)的測(cè)試，其中部分名詞或函數(shù)進(jìn)行了解釋說(shuō)明。直入主題2014-05-05
mysql中的delete,drop和truncate有什么區(qū)別
這篇文章主要介紹了mysql中的delete,drop和truncate有什么區(qū)別，三者的用法和使用場(chǎng)景又完全不同，接下來(lái)我們來(lái)看看具體的區(qū)別吧，希望對(duì)你的學(xué)習(xí)有所幫助2022-06-06
這篇文章主要介紹了進(jìn)入mysql命令行和退出mysql命令行，具有很好的參考價(jià)值，希望對(duì)大家有所幫助。如有錯(cuò)誤或未考慮完全的地方，望不吝賜教2022-11-11
本文主要介紹了MySQL字符串前綴索引使用，文中通過(guò)示例代碼介紹的非常詳細(xì)，對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值，需要的朋友們下面隨著小編來(lái)一起學(xué)習(xí)學(xué)習(xí)吧2023-02-02
mysql中復(fù)制表結(jié)構(gòu)的方法小結(jié)
這篇文章主要介紹了mysql中復(fù)制表結(jié)構(gòu)的方法,需要的朋友可以參考下2014-07-07
mysql中update和select結(jié)合使用方式
這篇文章主要介紹了mysql中update和select結(jié)合使用方式,具有很好的參考價(jià)值,希望對(duì)大家有所幫助,如有錯(cuò)誤或未考慮完全的地方,望不吝賜教2023-08-08
這篇文章主要介紹了MySQL中replace into語(yǔ)句的用法詳解,本文講解了replace into語(yǔ)句的多種寫(xiě)法,replace into語(yǔ)句的作用等內(nèi)容,需要的朋友可以參考下2014-08-08
這篇文章主要介紹了mysql 5.6.13 免安裝版配置的方法，今天小編把配置方法分享到腳本之家平臺(tái)供大家參考下2016-10-10
MySQL建立數(shù)據(jù)庫(kù)時(shí)字符集與排序規(guī)則的選擇詳解
當(dāng)數(shù)據(jù)庫(kù)需要適應(yīng)不同的語(yǔ)言就需要有不同的字符集,下面這篇文章主要給大家介紹了關(guān)于MySQL建立數(shù)據(jù)庫(kù)時(shí)字符集與排序規(guī)則的選擇的相關(guān)資料,文中通過(guò)實(shí)例代碼介紹的非常詳細(xì),需要的朋友可以參考下2023-06-06