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 <ishaq...@yahoo.co.uk> 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 > > > > -- Jim Lyons Web developer / Database administrator http://www.weblyons.com