开发者

Can i have LINEFEED as separator in CONCAT_WS function of mySQL

开发者 https://www.devze.com 2023-01-10 04:37 出处:网络
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 ?

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?

0

精彩评论

暂无评论...
验证码 换一张
取 消