Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > 记录mysql 的group_concat函数用方法_MySQL

记录mysql 的group_concat函数用方法_MySQL

WBOY
Release： 2016-06-01 13:44:59
Original
760 people have browsed it

bitsCN.com

表结构如下： 
id   rod_id  role_name 
1     1      超级管理员 
2     1      管理员 
3     1      系统管理员 
4     2      高级会员 
5     3      普通会员 
6     4      游客 

实现sql 
select role_id,group_concat(role_name) from roles group by role_id; 

这个在oracle10g以下版本中比较难实现，oracle10g中可以用WM_CONCAT函数

作者“yipbxx”
 

bitsCN.com
Related labels：
member administrator System administrator
source：php.cn
Previous article：mysql用户授权_MySQL Next article：mysql linux定时杀掉sleep进程_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
What are the best practices for displaying version information in web applications? I'm developing a web application. What are the best practices for displaying version infor...
From 2024-04-06 19:13:16
0
2
476
Group users (total users, admin users, control operators, guards) using Eloquent queries I have a query that counts all users, the total number of users with role "admin"...
From 2024-04-05 12:11:26
0
1
332
Undefined array index: children In the department management list, when adding a department, an error occurs. It displays:...
From 2024-04-05 15:57:40
1
0
2418
Managing "user" entities between aggregates in DDD I'm trying to rewrite a monolithic application onto a modular monolithic application using...
From 2024-04-04 09:54:15
0
1
361
How to effectively apply custom "css" and "js" files to all admins in an application? I have custom css and js files, admin.py and overridden base.html located in templates/adm...
From 2024-04-03 20:54:06
0
1
400
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template