一列变两列
    SELECT SUBSTRING_INDEX(name, ‘=’, 1) AS city, SUBSTRING_INDEX(name, ‘=’, -1) AS name FROM TB_USER;
    ALTER TABLE TB_USER ADD COLUMN city VARCHAR(16) NULL;UPDATE TB_USER SET city = SUBSTRING_INDEX(name, ‘=’, 1),name = SUBSTRING_INDEX(name, ‘=’, -1);
    — 两列并一列
    SELECT id,title,GROUP_CONCAT(id,title ) FROM zc_tb_flow GROUP BY id,title