MySQL显示操作控制小技巧

MySQL 显现格式化一、使用G按行垂直显示结果未使用mysql> select * from wp_users limit 1,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> select * from wp_users limit 1,2G;*************************** 1. row *************************** ID: 2 user_login: NicholaJorgenson user_pass: $P$BrLC6ljpc5i6IvCw4V2dTHn.ZTrXd/1 user_nicename: nicholajorgenson user_email: almatrostelgt3776@yahoo.com user_url: user_registered: 2015-02-15 09:40:54user_activation_key: user_status: 0 display_name: NicholaJorgenson*************************** 2. row *************************** ID: 3 user_login: ElvinMoney user_pass: $P$BebFywousFh0mVmoqHEWAx7IofQmEJ0 user_nicename: elvinmoney user_email: alizanoguera@mailcatch.com user_url: user_registered: 2015-02-15 10:04:36user_activation_key: user_status: 0 display_name: ElvinMoney2 rows in set （0.00 sec）二、使用pager来设置翻页pager "more" 此模式会显示一页，等待按键再显示一页 pager "less" 此模式会显示一页，等待按键再显示一行nopager 此模式直接显示到最完三、使用tee保存运行结果到文件，类似于Oracle中的spool命令mysql> tee test.txtLogging to file "test.txt"select * from wp_users limit 1,2; mysql> noteemysql> quitBye [mysql@sam ~]$ cat test.txtmysql> select * from wp_users limit 1,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> notee[mysql@sam ~]$ 四、直接执行操作系统命令mysql> system ls -ltotal 10092-rw-rw-r-- 1 mysql mysql 1638854 Apr 22 16:05 backup1.sql-rw-rw-r-- 1 mysql mysql 1767787 Apr 23 10:49 backup2.sql-rw-rw-r-- 1 mysql mysql 13807 Apr 23 09:48 backup3.sql-rw-rw-r-- 1 mysql mysql 12258 Apr 23 10:53 backup4.sql-rw-rw-r-- 1 mysql mysql 2293238 Apr 23 11:03 backup5.sql-rw-rw-r-- 1 mysql mysql 2297583 Apr 23 11:16 backup6.sql-rw-rw-r-- 1 mysql mysql 2297579 Apr 23 11:23 backup7.sql-rw-rw-r-- 1 mysql mysql 1280 Aug 26 11:18 test.txt五、执行SQL文件脚本mysql> source 1.sql+----+------------------+------------------------------------+------------------+-----------------------------+----------+---------------------+---------------------+-------------+------------------+| 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.sqlselect * from wp_users limit 1,2;mysql> 六、修改命令提示符mysql> prompt u@h（d） :m:s:>PROMPT set to "u@h（d） :m:s:>" sam@localhost（wordpress） 03:15:28:>本文永久更新链接地址