Re^2: Select DB data into CSV file

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". ;-)

Comment on Re^2: Select DB data into CSV file Download Code

Replies are listed 'Best First'.
Re^3: Select DB data into CSV file by kschwab (Vicar) on Dec 20, 2018 at 16:58 UTC
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]