SELECT GROUP_CONCAT(`f1` SEPARATOR ",") INTO @sql1
FROM `t1` ORDER BY `id` ASC; -- 排序不起作用
SELECT @sql1;
...全文
7312打赏收藏
排序不起作用
SELECT `f1` FROM `t1` ORDER BY `id` ASC; 这样可以正常排序。 SELECT GROUP_CONCAT(`f1` SEPARATOR ",") INTO @sql1 FROM `t1` ORDER BY `id` ASC; -- 排序不起作用 SELECT @sql1;