2 rows in set (0.00 sec)

mysql> notee

[mysql@sam ~]$?

四、直接执行操作系统命令

mysql> system ls -l

total 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.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:>