Include headers when using SELECT INTO OUTFILE?

by

You’d have to hard code those headers yourself. Something like:

SELECT 'ColName1', 'ColName2', 'ColName3'
UNION ALL
SELECT ColName1, ColName2, ColName3
    FROM YourTable
    INTO OUTFILE '/path/outfile'

More Related Contents:

  1. How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?
  2. MYSQL into outfile “access denied” – but my user has “ALL” access.. and the folder is CHMOD 777
  3. MySQL export into outfile : CSV escaping chars
  4. MySQL – SELECT * INTO OUTFILE LOCAL ?
  5. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  6. How can I make SQL case sensitive string comparison on MySQL?
  7. Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
  8. Count the occurrences of DISTINCT values
  9. Column count doesn’t match value count at row 1
  10. INSERT INTO … SELECT FROM … ON DUPLICATE KEY UPDATE
  11. Connect to mysql on Amazon EC2 from a remote server
  12. Docker-compose check if mysql connection is ready
  13. SQL: selecting rows where column value changed from previous row
  14. What is the location of mysql client “.my.cnf” in XAMPP for Windows?
  15. MySQL WHERE IN ()
  16. Using MySql with Entity Framework 4 and the Code-First Development CTP
  17. MySQL treats ÅÄÖ as AAO?
  18. MySQL – Supertype/Subtype design
  19. How can write queries in MySQL that can parse JSON data in a column?
  20. MySQL Time Zones
  21. How to use django models with foreign keys in different DBs?
  22. How can I undo a mysql statement that I just executed?
  23. Continue SQL query even on errors in MySQL workbench
  24. Which DATATYPE is better to use TEXT or VARCHAR?
  25. How to generate a UUIDv4 in MySQL?
  26. How can “set timestamp” be a slow query?
  27. INSERT INTO Table from multiple tables
  28. Mysql How do you create a clustered index?
  29. Counting associated entries with Sequelize
  30. MySQL data directory location

Leave a Comment