KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have a query that exports data from two columns of each row into a file. In the file data from each column should be separated by carriage-return, something like this: row1column1 row1column2 row2column1 row2column2 row3column1 row3column2 I tried using char(13): SELECT CONCAT(column1, char(13), column2) FROM my_table INTO outfile 'my_file' and the output file seemed perfectly fine (each column data was in another line), but when I used it as input to a program that should accept described format, it didn't recognize it. However, when I manually erased all carriage-returns in the file and added them again by pressing "enter" key, my program recognized the file without a problem. When I tried with char(13), char(10), my output file looked like this: row1column1 \ row1column2 row2column1 \ row2column1 I'm sure I'm missing something obvious here :)
Tags (comma-separated)
Save Edits
Cancel