prompt命令可以在mysql提示符中显示当前用户、数据库、时间等信息 复制代码 代码如下: mysql -uroot -p --prompt="\\u@\\h:\\d \\r:\\m:\\s" 设置成功后： 复制代码 代码如下: Welcome to the MySQL monitor.
prompt命令可以在mysql提示符中显示当前用户、数据库、时间等信息复制代码 代码如下:mysql -uroot -p --prompt="\\u@\\h:\\d \\r:\\m:\\s>"设置成功后：复制代码 代码如下:Welcome to the MySQL monitor. Commands end with ; or \g.Your MySQL connection id is 5Server version: 5.1.60-log Source distributionCopyright (c) 2000, 2012, 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) 11:04:23>也可以在在my.cnf配置文件里进行配置：复制代码 代码如下:[mysql] prompt=mysql(\\u@\\h:\\d)> default-character-set=utf8 选项说明: 复制代码 代码如下: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.jb51.net 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
