mysql 分割成行

-- 创建示例表
CREATE TABLE example_table (id INT, data VARCHAR(255));

-- 插入示例数据
INSERT INTO example_table (id, data) VALUES (1, 'apple,banana,orange');

-- 使用 SUBSTRING_INDEX 函数进行分割
SELECT id, SUBSTRING_INDEX(SUBSTRING_INDEX(data, ',', numbers.n), ',', -1) AS value
FROM example_table
JOIN (
    SELECT 1 n UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5
) numbers
WHERE numbers.n <= LENGTH(data) - LENGTH(REPLACE(data, ',', '')) + 1;

SELECT id, SUBSTRING_INDEX(SUBSTRING_INDEX(REPLACE(data, '\\n', ''), ',', numbers.n), ',', -1) AS value
FROM example_table
JOIN (
    SELECT 1 n UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5
) numbers
WHERE numbers.n <= LENGTH(REPLACE(data, '\\n', '')) - LENGTH(REPLACE(REPLACE(data, '\\n', ''), ',', '')) + 1;