You can use the --xml option to the mysql command to get xnl output. You
can also get a tab-delimited output file that can be read into Excel (this
is what I usually do).
To get a tab-delimited file, you can use the --tab option of mysqldump or
start up the mysql program with the -sss option and do a select on the data
you want, redirecting it into an output file.
On Tue, Jan 5, 2010 at 7:17 AM, ishaq gbola <ishaqgbo@stripped> wrote:
> Hi all,
> I would like to know if there is a tool or command in mySQL that allows one
> to export the result of query into excel formart
Web developer / Database administrator