CODEWITHSUNDEEP
mysqlexcel
siva636
siva636

Reputation: 16441

Analyse MySQL data on Excel

Is it possible export MySQL data to Microsoft 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)

Upvotes: 0

Views: 189

Answers (4)

David Bailey
David Bailey

Reputation: 623

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.

Upvotes: 0

Naveed Kamran
Naveed Kamran

Reputation: 169

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.

Upvotes: 0

TomaszSobczak
TomaszSobczak

Reputation: 2926

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

Upvotes: 0

stacker
stacker

Reputation: 68962

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;

Upvotes: 1

Related Questions