如何在sql中每8个字符后添加斜杠

SELECT GROUP_CONCAT(CONCAT(SUBSTRING(your_column, (8 * (n - 1)) + 1, 8), '/')) AS result
FROM (
  SELECT your_column, (FLOOR((CHAR_LENGTH(your_column) - 1) / 8) + 1) AS num_segments
  FROM your_table
) AS t
CROSS JOIN (
  SELECT 1 AS n UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL
  SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8
) AS numbers
WHERE (8 * (n - 1)) + 1 <= CHAR_LENGTH(your_column)
GROUP BY your_column, num_segments