mysql -prompt选项

dog1888

mysql -prompt选项
　　原文：http://www.cnblogs.com/abclife/p/5632826.html
　　使用-pormpt修改提示符。可以在登录时或者在登录后使用prompt选项来修改提示符
　　(1)使用mysql命令行参数修改提示符
12345678910111213141516171819202122232425262728293031323334353637# mysql -u root -pEnter password:Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 27Server version: 5.6.25 Source distribution Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> # 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 28Server version: 5.6.25 Source distribution Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. #切换数据库root@localhost:(none) 10:05:25>use testReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -A Database changedroot@localhost:test 10:05:31>　　(2)修改配置文件/etc/my.cnf
12[mysql]prompt="\\u@\\h:\\d \\r:\\m:\\s>"　　(3)在 MySQL 中使用 prompt 命令
12345mysql> prompt \r:\m:\s\P>\_PROMPT set to \'\r:\m:\s\P>\_\'08:20:42pm> promptReturning to default PROMPT of mysql>mysql>　　(4)当然可以在在Bash层修改 MYSQL_PS1变量
123456789101112131415161718192021# export MYSQL_PS1="(\u@\h) [\d]> "# mysql -u root -pEnter password:Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 31Server version: 5.6.25 Source distribution Copyright (c) 2000, 2015, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. (root@localhost) [(none)]> use testReading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -A Database changed(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