Questions tagged [mysq-8.0]

Questions which specifically cover the MySQL 8.0 server. It is not a generic MySQL tag - see new features below!

Much new functionality was introduced by this version - (RECURSIVE) CTEs , Window functions, enhanced JSON and Regex support. EXPLAIN ANALYZE. For more detail, see here.

1 questions

votes

2 answers

Recursive query on a self-referential table where each node has one link to its child's node

Consider the following table and data (fiddle available here): CREATE TABLE test ( id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY, next_id INTEGER NOT NULL ); INSERT INTO test (id, next_id) VALUES (1, 3), (2, 3), (3, 6), (4, 5), (5, 6), (6,…

asked Oct 29 '21 at 20:49

user1432193