MYSQL 命令行模式下用文件记录所作的操作
mysql> T tmp.out
Logging to file ‘tmp.out’
mysql> t
Outfile disabled.
?
?
例子:
?
C:Usersshiyu>d:
D:>cd D:Program Filesxamppmysqlbin
D:Program Filesxamppmysqlbin>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)
<span style="fo