mysql 命令行模式下用文件记录所作的操作
mysql> /T tmp.out
Logging to file ‘tmp.out’
mysql> /t
Outfile disabled.
例子：
C:/Users/shiyu>d:
D:/>cd D:/Program Files/xampp/mysql/bin
D:/Program Files/xampp/mysql/bin>mysql -h localhost -u root -p
Enter password: ****
Welcome to the MySQL monitor. Commands end with ; or /g.
Your MySQL connection id is 1 to server version: 5.0.27-community
Type ‘help;’ or ‘/h’ for help. Type ‘/c’ to clear the buffer.
mysql> /T tmp.out
Logging to file ‘tmp.out’
mysql> use cookbook;
Database changed
mysql> show tables;
+——————–+
| Tables_in_cookbook |
+——————–+
| limbs |
+——————–+
1 row in set (0.03 sec)
mysql> select * from limbs;
+————–+——+——+
| thing | legs | arms |
+————–+——+——+
| human | 2 | 2 |
| insect | 6 | 0 |
| squid | 0 | 10 |
| octopus | 0 | 8 |
| fish | 0 | 0 |
| centipede | 100 | 0 |
| table | 4 | 0 |
| armchair | 4 | 2 |
| phonograph | 0 | 1 |
| tripod | 3 | 0 |
| Peg Leg Pete | 1 | 2 |
| space alien | NULL | NULL |
+————–+——+——+
12 rows in set (0.04 sec)
‘tmp.out’文件打开后的内容：
mysql> use cookbook;
Database changed
mysql> show tables;
+——————–+
| Tables_in_cookbook |
+——————–+
| limbs |
+——————–+
1 row in set (0.03 sec)
mysql> select * from limbs;
+————–+——+——+
| thing | legs | arms |
+————–+——+——+
| human | 2 | 2 |
| insect | 6 | 0 |
| squid | 0 | 10 |
| octopus | 0 | 8 |
| fish | 0 | 0 |
| centipede | 100 | 0 |
| table | 4 | 0 |
| armchair | 4 | 2 |
| phonograph | 0 | 1 |
| tripod | 3 | 0 |
| Peg Leg Pete | 1 | 2 |
| space alien | NULL | NULL |
+————–+——+——+
12 rows in set (0.04 sec)
转载请注明原文链接：MYSQL 命令行模式上用文件记录所作的操作
