MySQL Forums
Forum List  »  Backup

Export data with column names
Posted by: André Cardoso
Date: May 22, 2006 04:29AM

Hello,

I am trying to export some tables with the following command:
mysqldump -uUSER -pPASSWORD --compact database table > path;
or from a query:
select * from table into outfile file.txt;

I just need to export a simple file to read with column names included and i won't need to backup this file later.. it's really just for reading.
Usually has this format(separated by tab):

column name1 column name2
field1 field2

Can you help me please? .
My major problem is that i can't export column names..

Thanks

Andre Cardoso

Options: ReplyQuote


Subject
Views
Written By
Posted
Export data with column names
5911
May 22, 2006 04:29AM


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.