Solved

select into outfile error

Posted on 2010-11-16
2
525 Views
Last Modified: 2012-05-10
Hi

I have this command

mysql> SELECT * INTO OUTFILE
    -> "C:\outfile.txt"
    -> FIELDS TERMINATED BY '\t'
    -> LINES TERMINATED BY '\n'
    -> FROM employee;
Query OK, 4 rows affected (0.00 sec)


which seems to have ran ok, but the output file c:\outfile.txt is actually in c:\program files\mysql\mysql server 5.0 \data

thanks
0
Comment
Question by:andieje
2 Comments
 
LVL 11

Accepted Solution

by:
JoeNuvo earned 500 total points
ID: 34151585
should it be c:\\outfile.txt ?
0
 

Author Closing Comment

by:andieje
ID: 34154611
you're absolutely right!
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question