MySQL Forums
Forum List  »  CSV Storage Engine

Export Table to Excel Sheet
Posted by: Victor Hernan Zevallos Puppi
Date: May 17, 2011 11:35PM

Hello, im wondering, this:

I have one table, and i want to export it to a CSV file.I know how to use the select * from table INTO OUTFILE '/tmp/test.txt', BUT Thats not the problem.

For Example:

TABLE users
------------
id names
1 jerry
2 michael

i want this table ordered by fields in CSV, but all appears in the first COLUMN of the excel....


CSV FIELDS
-----------
A1=1 jerry
A2=2 michael

So, how can i put the data, ordered in each field of the excel ?.... like this:

CSV FIELDS
-----------
A1=1 B1=jerry
A2=2 B2=michael

My email is victorzp86@hotmail.com, THANK YOU VERY MUCH.

Options: ReplyQuote


Subject
Views
Written By
Posted
Export Table to Excel Sheet
11495
May 17, 2011 11:35PM


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.