1. 语法格式.
select... from 表名
into outfile "文件名"
fields terminated by "分隔符"
lines terminated by "分隔符"
�2.实际演练.
mysql> select * from userinfo02
-> into outfile"/var/lib/mysql-files/userinfo.txt"
-> fields terminated by ":"
-> lines terminated by "\n";
Query OK, 47 rows affected (0.00 sec)
3.查看文件.
root@tedu:/var/lib/mysql-files# cat userinfo.txt
root:x:0:0:root:/root:/bin/bash
daemon:x:1:1:daemon:/usr/sbin:/usr/sbin/nologin
bin:x:2:2:bin:/bin:/usr/sbin/nologin
OK .
阿基米德
