MySQL显示操作控制小技巧(2)

+----+------------------+------------------------------------+------------------+-----------------------------+----------+---------------------+---------------------+-------------+------------------+

| ID | user_login      | user_pass                          | user_nicename    | user_email                  | user_url | user_registered    | user_activation_key | user_status | display_name    |

+----+------------------+------------------------------------+------------------+-----------------------------+----------+---------------------+---------------------+-------------+------------------+

|  2 | NicholaJorgenson | $P$BrLC6ljpc5i6IvCw4V2dTHn.ZTrXd/1 | nicholajorgenson | almatrostelgt3776@yahoo.com |          | 2015-02-15 09:40:54 |                    |          0 | NicholaJorgenson |

|  3 | ElvinMoney      | $P$BebFywousFh0mVmoqHEWAx7IofQmEJ0 | elvinmoney      | alizanoguera@mailcatch.com  |          | 2015-02-15 10:04:36 |                    |          0 | ElvinMoney      |

+----+------------------+------------------------------------+------------------+-----------------------------+----------+---------------------+---------------------+-------------+------------------+

2 rows in set (0.00 sec)

mysql> system cat 1.sql

select * from wp_users limit 1,2;

mysql> 

六、修改命令提示符

mysql> prompt \u@\h(\d) \r:\m:\s:>

PROMPT set to '\u@\h(\d) \r:\m:\s:>'

sam@localhost(wordpress) 03:15:28:>