MySQL Remove line breaks before CSV export

If you want to export the data from a MySQL table to a CSV file, often line breaks are making trouble. Because newlines are interpreted as the end of a row within the CSV file, we can quickly destroy the export data.

replace(column, CHAR(13,10), '')
#1046
1 month ago