我就纳~了~闷~儿~了,怎么我select * from tablename into outfile 'c:\aa.txt' 就在c:\中找不到aa.txt呢?
呵呵,上面说错了,应该是: mysql> select * from aa into outfile 'aa.txt'; Query OK, 1 row affected (0.00 sec)这样文件aa.txt应该在aa所属数据库的目录下,例如:我mysql是按照默认装的,所以执行上面的操作后,我就可以在C:\Program Files\MySQL\MySQL Server 5.0\data\test找到.指定路径的话还应该加多一斜杠见如下: mysql> select * from aa into outfile 'c:\\aa.txt'; Query OK, 1 row affected (0.00 sec)或者这样mysql> select * from aa into outfile 'c:/aa.txt'; Query OK, 1 row affected (0.00 sec)
mysql> select * from log into outfile 'c:\\a.txt'; Query OK, 529 rows affected (0.00 sec)mysql> select * from log into outfile 'c:\\a.txt'; ERROR 1086 (HY000): File 'c:\a.txt' already exists ------------------------------------ 可是我在c:\下就是找不到a.txt,在整个硬盘里也找不到a.txt,我这个晕~~~~
就在c:\中找不到aa.txt呢?
mysql> select * from aa into outfile 'aa.txt';
Query OK, 1 row affected (0.00 sec)这样文件aa.txt应该在aa所属数据库的目录下,例如:我mysql是按照默认装的,所以执行上面的操作后,我就可以在C:\Program Files\MySQL\MySQL Server 5.0\data\test找到.指定路径的话还应该加多一斜杠见如下:
mysql> select * from aa into outfile 'c:\\aa.txt';
Query OK, 1 row affected (0.00 sec)或者这样mysql> select * from aa into outfile 'c:/aa.txt';
Query OK, 1 row affected (0.00 sec)
Query OK, 529 rows affected (0.00 sec)mysql> select * from log into outfile 'c:\\a.txt';
ERROR 1086 (HY000): File 'c:\a.txt' already exists
------------------------------------
可是我在c:\下就是找不到a.txt,在整个硬盘里也找不到a.txt,我这个晕~~~~