本文通过实例演示了如何使用MySQL命令将查询结果导出到文件中。具体操作包括登录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)
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
