Can i have LINEFEED as separator in CONCAT_WS function of mySQL
I am using a mySQL CONCAT_WS()
function to get a set of comma separated values.
I need the output to appear as a set of rows instead of a CSV. How can thi开发者_运维技巧s be done ?
Thanks, Chak.
SELECT CONCAT_WS("\n", "row1", "row2", "row3");
> row1
row2
row3
Is that what you wanted?
精彩评论