如何根据具有相同元素的列将一个SQL表拆分为多个？

-- 创建一个存储过程来拆分表
DELIMITER //

CREATE PROCEDURE split_table_by_column()
BEGIN
    DECLARE done INT DEFAULT FALSE;
    DECLARE column_value VARCHAR(255);
    DECLARE cur CURSOR FOR SELECT DISTINCT column_a FROM table_name;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    OPEN cur;

    read_loop: LOOP
        FETCH cur INTO column_value;
        IF done THEN
            LEAVE read_loop;
        END IF;

        -- 创建子表
        SET @sub_table_name = CONCAT('sub_table_', column_value);
        SET @sql = CONCAT('CREATE TABLE ', @sub_table_name, ' AS SELECT * FROM table_name WHERE column_a = "', column_value, '";');
        PREPARE stmt FROM @sql;
        EXECUTE stmt;
        DEALLOCATE PREPARE stmt;
    END LOOP;

    CLOSE cur;
END//

DELIMITER ;

CALL split_table_by_column();