Shulou(Shulou.com)05/31 Report--

This article introduces how to use the group_concat function in mysql, the content is very detailed, interested friends can refer to, hope to be helpful to you.

The table structure is as follows:

Id rod_id role_name

1 1 Super Admin

2 1 administrator

3 1 system administrator

4 2 Senior members

5 3 ordinary members

6 4 tourists

Implement sql

Select role_id,group_concat (role_name) from roles group by role_id

This is difficult to implement in the following versions of oracle10g, where the WM_CONCAT function can be used in oracle10g

On how to use the group_concat function in mysql to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.