How to export / dump a MySql table into a text file including the field names (aka headers or column names)

by

Piping the query to the commandline client outputs a tab separated list with the column names as the first line

$ echo "select * from surveys limit 5" | mysql -uroot -pGandalf surveys
phone   param1  param2  param3  param4  p0      p1      p2      p3      audio4  code    time
XXXXXXXXX       2008-07-02      11:17:23        XXXXXXXX        SAT     -       -       -       -       -       ERROR   2008-07-02 12:18:32
XXXXXXXXX       2008-07-02      11:22:52        XXXXXXXX        SAT     -       -       -       -       -       COLGADO 2008-07-02 12:04:29
XXXXXXXXX       2008-07-02      11:41:29        XXXXXXXX        SAT     -       -       -       -       -       COLGADO 2008-07-02 12:07:22
XXXXXXXXX       2008-07-02      12:16:19        XXXXXXXX        SAT     1       1       1       9       XXXXXXXXX_4.wav     OK      2008-07-02 16:14:27
XXXXXXXXX       2008-07-02      08:21:25        XXXXXXXX        SAT     1       1       1       1       XXXXXXXXX_4.wav     OK      2008-07-02 12:29:40

More Related Contents:

  1. How can I get rid of these comments in a MySQL dump?
  2. How to remove leading and trailing whitespace in a MySQL field?
  3. Exporting results of a Mysql query to excel?
  4. Doctrine 2 mysql FIELD function in order by
  5. When I want to install MySQL I faced this issue “root account password” I forgot it
  6. How to perform grouped ranking in MySQL
  7. How to abort INSERT operation in MySql trigger?
  8. Restoring MySQL database from physical files
  9. MySQL Trigger after update only if row has changed
  10. MySQL Query – Records between Today and Last 30 Days
  11. MySQL “Group By” and “Order By”
  12. MySQL Query to select data from last week?
  13. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  14. Migrate from Oracle to MySQL
  15. Which is more efficient: Multiple MySQL tables or one large table?
  16. #1139 – Got error ‘repetition-operator operand invalid’ from regexp
  17. How to skip columns in CSV file when importing into MySQL table using LOAD DATA INFILE?
  18. MySQL ‘user_id’ in where clause is ambiguous problem
  19. Images in MySQL
  20. adding RMySQL package to R fails (on Windows)?
  21. How to add a where clause in a MySQL Insert statement?
  22. MySQL “IN” queries terribly slow with subquery but fast with explicit values
  23. Use MySQL to determine whether today is a user’s birthday
  24. How can you determine how much disk space a particular MySQL table is taking up?
  25. How to create and insert a JSON object using MySQL queries?
  26. Query to count the number of tables I have in MySQL
  27. `MODIFY COLUMN` vs `CHANGE COLUMN`
  28. INSERT INTO Table from multiple tables
  29. Mysql How do you create a clustered index?
  30. Counting associated entries with Sequelize

Leave a Comment