mysql导出数据
摘要：
方法一：SELECT...INTO OUTFILEmysql> select * from mytbl into outfile '/tmp/mytbl.txt';Query OK, 3 rows affected (0.00 sec)查看mytbl.txt中内容如下：mysql> system cat /tmp/mytbl.txt1 name12 name23 \N导出的文件中数据以制表符分隔，以"\n"为换行符mysql> system od -c /tmp/mytbl.txt0000000 1 \t n a m e 1 \n 2 \t 阅读全文
posted @ 2012-07-02 23:30 Leon_He 阅读(12573) 评论(0) 推荐(2) 编辑