-- the 'data' field means nothing. it's just an arbitrary text INSERT INTO test (parent, data) VALUES(1, 'root:A'); -- id:2 INSERT INTO test (parent, data) VALUES(1, 'root:B'); -- id:3 INSERT INTO test (parent, data) VALUES(2, 'root:A:A'); -- id:4 INSERT INTO test (parent, data) VALUES(2, 'root:A:B'); -- id:5 INSERT INTO test (parent, data) VALUES(5, 'root:A:B:A'); -- id:6 INSERT INTO test (parent, data) VALUES(1, 'root:C'); -- id:7