要進行合并,請使用GROUP_CONCAT()函數将兩行中的某些屬性合并為一。作為連字元,請使用連字元。
讓我們首先建立一個表-mysql> create table DemoTable1386
-> (
-> Title varchar(255),
-> Name varchar(60)
-> );
使用插入指令在表中插入一些記錄-mysql> insert into DemoTable1386 values('Introduction to MySQL','Paul DuBois');
mysql> insert into DemoTable1386 values('Java in Depth','Khalid Mughal');
mysql> insert into DemoTable1386 values('Introduction to MySQL','Russell Dyer');
mysql> insert into DemoTable1386 values('Java in Depth','Joshua Bloch');
使用select語句顯示表中的所有記錄-mysql> select * from DemoTable1386;
這将産生以下輸出-+-----------------------+---------------+
| Title | Name |
+-----------------------+---------------+
| Introduction to MySQL | Paul DuBois |
| Java in Depth | Khalid Mughal |
| Introduction to MySQL | Russell Dyer |
| Java in Depth | Joshua Bloch |
+-----------------------+---------------+
4 rows in set (0.00 sec)
以下是合并重複值的查詢-mysql> select Title,group_concat(Name separator '----') from DemoTable1386
-> group by Title;
這将産生以下輸出-+-----------------------+-------------------------------------+
| Title | group_concat(Name separator '----') |
+-----------------------+-------------------------------------+
| Introduction to MySQL | Paul DuBois----Russell Dyer |
| Java in Depth | Khalid Mughal----Joshua Bloch |
+-----------------------+-------------------------------------+
2 rows in set (0.00 sec)