Solved

select into outfile error

Posted on 2010-11-16
2
518 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MySQL 11 80
PHP - modify class to use temporary MySQL table? 15 53
PHP strip quotes and line feeds out of array 13 49
selecting date modified field from a table 2 39
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

863 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

Need Help in Real-Time?

Connect with top rated Experts

27 Experts available now in Live!

Get 1:1 Help Now