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), '')
Hi. This is me. I’m Wossi.
Rico Wosnitzka (also known as Wossi) is a German web and game developer, digital artist and multimedia producer. Based in Austria since 2009. He loves pixel art, the 80s, Synthwave and also his creative solutions. Currently working full-time with clubdrei. Sometimes, he need a place to be… so, here it is!