当前位置：网站首页>MySQL multi line data synthesis one line function group_ CONCAT

MySQL multi line data synthesis one line function group_ CONCAT

2022-07-21 17:27:00 【February 16】

         When we operate data , Sometimes you need to put multiple rows of data , Put it together in a line , Use characters （ For example, comma ） Separate ,SQLSERVER have access to for xml path In the form of ,MySQL The corresponding function is also provided GROUP_CONCAT, To deal with the needs of this scenario .

        The usage function ：

GROUP_CONCAT([DISTINCT] Fields to connect [ORDER BY Sort field ASC/DESC] [SEPARATOR ' Separator '])

        Test data ：

SELECT
	pushuserid,
	orderkeywords
FROM
	xn_keywords
ORDER BY pushuserid

        

        Use functions to handle ：

SELECT
	pushuserid,
	GROUP_CONCAT(
		`orderkeywords`
		ORDER BY
			pushuserid SEPARATOR ','
	) orderkeywords
FROM
	xn_keywords
GROUP BY
	pushuserid

          give the result as follows ：

 

原网站

版权声明
本文为[February 16]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/202/202207202301563406.html

边栏推荐

猜你喜欢

随机推荐