in reply to Select DB data into CSV file

Mysql's "INTO OUTFILE" supports "ESCAPED BY" "ENCLOSED BY" and other parameters that you could probably tweak to make it safe.

Replies are listed 'Best First'.
Re^2: Select DB data into CSV file
by afoken (Chancellor) on Dec 20, 2018 at 16:52 UTC
    Mysql's "INTO OUTFILE"

    SELECT ... INTO OUTFILE writes to a file on the database server's filesystem (if permitted), whereas a classic SELECT + Text::CSV as proposed in Re^3: Select DB data into CSV file writes to the client's filesystem. And SELECT ... INTO OUTFILE is not portable across databases.

    Alexander

    --
    Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)
[reply]
[d/l]
      Sure, but the original post mentions the team is considering it, just with the unsafe assumption that TAB characters won't be in the data.
[reply]

In Section Seekers of Perl Wisdom