MySQL Forums
Forum List  »  Newbie

Re: LOOKING FOR UNLOAD
Posted by: Felix Geerinckx
Date: April 15, 2005 02:43AM

Joe Cotton wrote:

> But I am still looking for the inverse command, an
> UNLOAD that will convert a MySQL table to
> tab-delimited csv file. That is, to go the other
> way. Is there such a command? I have been thru
> the fine manual back and forth, did searches, etc.
> but no luck.

Try

echo SELECT * FROM foo | mysql -uusername -ppassword your_database >foo.txt

--
felix

Options: ReplyQuote


Subject
Written By
Posted
April 14, 2005 01:24PM
Re: LOOKING FOR UNLOAD
April 15, 2005 02:43AM


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.