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)