MySQL export into outfile : CSV escaping chars

by

I think your statement should look like:

SELECT id, 
   client,
   project,
   task,
   description, 
   time,
   date  
  INTO OUTFILE '/path/to/file.csv'
  FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
  LINES TERMINATED BY '\n'
  FROM ts

Mainly without the FIELDS ESCAPED BY '""' option, OPTIONALLY ENCLOSED BY '"' will do the trick for description fields etc and your numbers will be treated as numbers in Excel (not strings comprising of numerics)

Also try calling:

SET NAMES utf8;

before your outfile select, that might help getting the character encodings inline (all UTF8)

Let us know how you get on.

More Related Contents:

  1. How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?
  2. MySQL – SELECT * INTO OUTFILE LOCAL ?
  3. get first occurrence of last changed value of a column [closed]
  4. SQL Print the name of all Employees together with the name of their supervisor
  5. MySQL – Rows to Columns
  6. ROW_NUMBER() in MySQL
  7. How can I temporarily disable a foreign key constraint in MySQL?
  8. MySQL offset infinite rows
  9. Ordering by the order of values in a SQL IN() clause
  10. Creating a “Numbers Table” in MySQL
  11. SQL Selecting from two Tables with inner join and limit [duplicate]
  12. MySQL Group by SUM
  13. Get the latest date from grouped MySQL data
  14. In SQL, how to select the top 2 rows for each group
  15. Mysql query to dynamically convert rows to columns on the basis of two columns
  16. MySQL Error 1264: out of range value for column
  17. How to change the default port of mysql from 3306 to 3360
  18. Special Characters in MySQL Table Name
  19. Is it possible to reference one column as multiple foreign keys?
  20. MySQL: How do I join same table multiple times?
  21. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  22. Split a string and loop through values in MySQL stored procedure
  23. How to create dummy variable columns for thousands of categories in Google BigQuery?
  24. MySQL Select Query – Get only first 10 characters of a value
  25. Most efficient way to store IP Address in MySQL [duplicate]
  26. Getting first day of the week in MySql using Week No
  27. SQL date format convert? [dd.mm.yy to YYYY-MM-DD]
  28. mysql select id and name from other table and join query
  29. MySQL: Computed Column
  30. mySQL query to search all tables within a database for a string?

Leave a Comment