MySQL Forums
Forum List  »  Perl

table to output "into outfile"
Posted by: stuart spriggs
Date: August 22, 2006 08:42AM

Hello I'm having trouble saving a query to a text or csv file. There is the problem:
mysql> select * from eCBOT_ZN_Jun06_20060302 where id < 10 into outfile 'kss/lauradata.csv';
ERROR 1 (HY000): Can't create/write to file 'kss/lauradata.csv' (Errcode: 2)

I'm sure this is an easy fix but I'm new to both Linux and MySQL. Thanks.
KS

Options: ReplyQuote


Subject
Written By
Posted
table to output "into outfile"
August 22, 2006 08:42AM
September 09, 2006 12:50PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.