MySql 个性化设置提示符

MySql 个性化设置提示符

1. 基本语法
   输入mysql> prompt \u@\d;
   结果root@ddicar_v3;
2. 个性化内容
   
   • \D 当前日期
   • \d 当前数据库
   • \h 数据库主机
   • \l The current delimiter (new in 5.1.12)
   • \m 当前时间（分）
   • \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 当前时间（小时）(0–23)
   • \r 当前时间（小时）(1–12)
   • \S Semicolon
   • \s 当前时间（秒）
   • \t A tab character
   • \U Your full user_name@host_name account name
   • \u 数据库用户名
   • \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