MySQL的snafoo与GROUP_CONCAT

Question

这工作：

SELECT DISTINCT HEX(group_uuid) AS hexid 
FROM schema.table 

>9B3D8DE01E1E049DA9F17D42B324AA66 
>CDF112D740CE14EA08CA90E3C937DE8D 

为做到这一点

SELECT GROUP_CONCAT('\'', HEX(group_uuid), '\' ') AS hexid 
FROM schema.table 

>'9B3D8DE01E1E049DA9F17D42B324AA66','9B3D8DE01E1E049DA9F17D42B324AA66' [etc...] 

这

SELECT GROUP_CONCAT(DISTINCT HEX(group_uuid) SEPARATOR '\' ') AS hexid 
FROM schema.table 

>9B3D8DE01E1E049DA9F17D42B324AA66' CDF112D740CE14EA08CA90E3C937DE8D 

这一点，但是，

SELECT GROUP_CONCAT('\'', DISTINCT HEX(group_uuid), '\' ') AS hexid 
FROM schema.table 

Error Code: 1064. You have an error in your SQL syntax; INSERT COIN 

没有。

是否有某种'PREFIX'关键字可以被替换或我应该遵循的其他语法？

Answer 1

您是否在寻找

GROUP_CONCAT(DISTINCT CONCAT('\'',HEX(group_uuid),'\'') SEPARATOR ' ')