mysql利用group_concat()合并多行数据到一行
Jun 07, 2016 pm 04:29 PM假设两个表a,b，b中通过字段id与a表关联，a表与b表为一对多的关系。假设b表中存在一字段name，现需要查询a表中的记录，同时获取存储在b表中的name信息，按照常规查询，b表中有多少记录，则会显示多少行，如果需要只显示a表记录行数，则需要把查询name字段得
假设两个表a,b，b中通过字段id与a表关联，a表与b表为一对多的关系。假设b表中存在一字段name，现需要查询a表中的记录，同时获取存储在b表中的name信息，按照常规查询，b表中有多少记录，则会显示多少行，如果需要只显示a表记录行数，则需要把查询name字段得到的多行记录进行合并，可以通过程序实现，但也可直接在sql层完成。
方法：
利用group_concat()方法，参数为需要合并的字段，合并的字段分隔符默认为逗号，可通过参数separator指定，该方法往往配合group by 一起使用。
例子：
select a.*,group_concat(b.name separator '-') as name from a left join b on a.id=b.id group by a.id;
Hot Article
Hot tools Tags
Hot Article
Hot Article Tags
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
PHP's big data structure processing skills
May 08, 2024 am 10:24 AM
PHP's big data structure processing skills
The U.S. Air Force showcases its first AI fighter jet with high profile! The minister personally conducted the test drive without interfering during the whole process, and 100,000 lines of code were tested for 21 times.
May 07, 2024 pm 05:00 PM
The U.S. Air Force showcases its first AI fighter jet with high profile! The minister personally conducted the test drive without interfering during the whole process, and 100,000 lines of code were tested for 21 times.
How to optimize MySQL query performance in PHP?
Jun 03, 2024 pm 08:11 PM
How to optimize MySQL query performance in PHP?
Tesla robots work in factories, Musk: The degree of freedom of hands will reach 22 this year!
May 06, 2024 pm 04:13 PM
Tesla robots work in factories, Musk: The degree of freedom of hands will reach 22 this year!
How to use MySQL backup and restore in PHP?
Jun 03, 2024 pm 12:19 PM
How to use MySQL backup and restore in PHP?
How to insert data into a MySQL table using PHP?
Jun 02, 2024 pm 02:26 PM
How to insert data into a MySQL table using PHP?
How to fix mysql_native_password not loaded errors on MySQL 8.4
Dec 09, 2024 am 11:42 AM
How to fix mysql_native_password not loaded errors on MySQL 8.4
How to use MySQL stored procedures in PHP?
Jun 02, 2024 pm 02:13 PM
How to use MySQL stored procedures in PHP?
