table:
user1 | name |
A | E |
A | T |
B | H |
B | J |
结果:
A | E,T |
B | H,J |
SQL语句:
CREATE FUNCTION groupconcat(@user1 varchar)
RETURNS varchar(32)
BEGIN
DECLARE @str varchar(32);
SET @str='';
SELECT @str = @str + ',' + value from table where user1=@user1;
RETURN INSERT(@str,1,1,'');
END
select user1,name = groupconcat(user1) from table group by user1;
drop function groupconcat;