Exporting results of a Mysql query to excel?

by

The typical way to achieve this is to export to CSV and then load the CSV into Excel.
You can using any MySQL command line tool to do this by including the INTO OUTFILE clause on your SELECT statement:

SELECT ... FROM ... WHERE ... 
INTO OUTFILE 'file.csv'
FIELDS TERMINATED BY ','

See this link for detailed options.

Alternatively, you can use mysqldump to store dump into a separated value format using the –tab option, see this link.

mysqldump -u<user> -p<password> -h<host> --where=jtaskResult=2429 --tab=<file.csv> <database> TaskResult

Hint: If you don’t specify an absoulte path but use something like INTO OUTFILE 'output.csv' or INTO OUTFILE './output.csv', it will store the output file to the directory specified by show variables like 'datadir';.

More Related Contents:

  1. How to reduce the size of google spreadsheet using SQL?
  2. How to import an excel file in to a MySQL database
  3. Export MySQL data to Excel in PHP
  4. How can I get rid of these comments in a MySQL dump?
  5. How can VBA connect to MySQL database in Excel?
  6. How to save MySQL query output to excel or .txt file? [duplicate]
  7. MySQL export into outfile : CSV escaping chars
  8. How to export / dump a MySql table into a text file including the field names (aka headers or column names)
  9. Syntax error due to using a reserved word as a table or column name in MySQL
  10. MySQL update table based on another tables value
  11. On Duplicate Key Update same as insert
  12. Ordering by the order of values in a SQL IN() clause
  13. LAST_INSERT_ID() MySQL
  14. SQL Selecting from two Tables with inner join and limit [duplicate]
  15. How to export and import a .sql file from command line with options? [duplicate]
  16. a count for each join – optimisation
  17. Difference between VARCHAR and TEXT in MySQL [duplicate]
  18. The equivalent of SQLServer function SCOPE_IDENTITY() in mySQL?
  19. Are column and table name case sensitive in MySQL?
  20. MySQL – SELECT WHERE field IN (subquery) – Extremely slow why?
  21. Importing a CSV to MySQL with different date format
  22. Is there any performance gain in indexing a boolean field?
  23. Using version control (Git) on a MySQL database
  24. mySQL – Create a New Table Using Data and Columns from Three Tables
  25. Storing images in MySQL [closed]
  26. Laravel MySql DB Connection with SSH
  27. Automatic Rollback if COMMIT TRANSACTION is not reached
  28. Get column sum and use to calculate percent of total (mySQL)
  29. is there a length limit to group_concat or another reason why it would not work on a text field
  30. Sum until certain point – MySql

Leave a Comment