【MySQL】only_full_group_by 绕过
SELECT
origin.*,tmp.dbn_name_list
FROM
{ConstDatabaseMeta.DBMeta.DatabaseName}.{ConstDatabaseMeta.DBMeta.DDBMetaPolicy} AS origin,
(SELECT
MAX(id) AS id,name, JSON_ARRAYAGG(dbn_name) AS dbn_name_list
FROM
{ConstDatabaseMeta.DBMeta.DatabaseName}.{ConstDatabaseMeta.DBMeta.DDBMetaPolicy}
WHERE
ddb_ip=‘{ip}‘
AND
dbi_port={dbiPort}
GROUP BY
name) AS tmp
WHERE
origin.id = t.id
参考
相关推荐
CoderToy 2020-11-16
emmm00 2020-11-17
王艺强 2020-11-17
ribavnu 2020-11-16
bianruifeng 2020-11-16
wangshuangbao 2020-11-13
苏康申 2020-11-13
vivenwan 2020-11-13
moyekongling 2020-11-13
云中舞步 2020-11-12
要啥自行车一把梭 2020-11-12
aydh 2020-11-12
kuwoyinlehe 2020-11-12
minerk 2020-11-12
vitasfly 2020-11-12
jazywoo在路上 2020-11-11
敏敏张 2020-11-11
世樹 2020-11-11