Group_concat不是内置函数 - HeidiSQL

Question

我有一个查询，其中有一个group_concat，但它返回一个错误，即group_concat不是内置函数。请帮我解决这个问题。我的查询是这样的：

SELECT cast(user_id as varchar(255)) AS member_id,skincareproductbarcode.barcode, skincareproduct.SCP_id, skincabinet.beautybox_id, 
     skincabinet.skpid, skincareproduct.photos, skincabinet.create_date, GROUP_CONCAT(MirrorProfile.serial_number, '') As Serial_Number 
     from skincabinet join skincareproduct on skincareproduct.scp_id = skincabinet.skpid 
     full join skincareproductbarcode on skincabinet.skpid = skincareproductbarcode.scp_id 
      full join membermirrorprofile on skincabinet.user_id = membermirrorprofile.member_id 
      full join mirrorprofile on MemberMirrorProfile.mirror_id = mirrorProfile.mirror_id 
      where skincareproduct.approval_flag = 'N' and skincareproduct.photos != '' 
      and substring(photos,52,3) = 'scp' order by skincareproduct.SCP_id group by skincareproduct.scp_id desc 

如何使用group_concat或者有没有其他解决方法？

Answer 1

字段的concat不应该是SQL查询的输出。这不是为了这个。使用接收数据的工具来执行此操作。