Analyse MySQL data on Excel

Is it possible export MySQL data to Micro开发者_开发百科soft Excell where I can analyze the data in a graphical format?

(Please tell me the procedures regarding this or guide me to any block entries or tutorials)

You could export the data in a CSV-File and read this from excel

SELECT col1,col2 INTO OUTFILE '/tmp/result.csv' 
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' 
LINES TERMINATED BY '\n' 
FROM yourtable; 

You can use this library for example as a middleware for exporting data

You can use "SqlYog"
www.webyog.com
tool to import / export data to/from MySQL DB. Its a good tool for performing different operations on MySQL DB.

I use Sequel Pro and the easiest way is to select all the data you want in Excel and select all in the data viewer. Then, CTRL+C/V into the Excel spreadsheet.

SELECT * FROM db;

Hope this helps.