Mysql合并行

xiaoxiao2021-02-28  59

创建表

-- 合并行 group_concat(list, separeator ',') drop table if exists table1; create table table1( company_name varchar(20) not null, person_name varchar(20) not null, person_position varchar(20) not null ); insert into table1(company_name, person_name, person_position) values ('bonc','chen','manager'); insert into table1(company_name, person_name, person_position) values ('bonc','yu','manager'); insert into table1(company_name, person_name, person_position) values ('baidu','sun','inv'); insert into table1(company_name, person_name, person_position) values ('baidu','zhou','manager');

图示:

合并行

select t.company_name, group_concat(t.name_position separator '||') as name_position from ( -- 合并字段列 concat select company_name, concat(person_name,'@',person_position) as name_position from table1 ) t group by company_name;

图示:

转载请注明原文地址: https://www.6miu.com/read-2612890.html

最新回复(0)