在MySQL中创建链表或类似队列？

CREATE TABLE linked_list (
  id INT PRIMARY KEY,
  next_id INT
);

INSERT INTO linked_list (id, next_id) VALUES (1, 2);
INSERT INTO linked_list (id, next_id) VALUES (2, 3);
INSERT INTO linked_list (id, next_id) VALUES (3, NULL);

DELIMITER //
CREATE TRIGGER update_linked_list
AFTER INSERT ON linked_list
FOR EACH ROW
BEGIN
  DECLARE last_id INT;
  SET last_id = NEW.id;
  
  WHILE NEW.next_id IS NOT NULL DO
    UPDATE linked_list SET next_id = last_id WHERE id = NEW.next_id;
    SET last_id = NEW.next_id;
    SELECT next_id INTO NEW.next_id FROM linked_list WHERE id = NEW.next_id;
  END WHILE;
END //
DELIMITER ;

INSERT INTO linked_list (id, next_id) VALUES (4, NULL);