MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Table1 (Id INT AUTO_INCREMENT PRIMARY KEY, 
                     Name VARCHAR(255)) AUTO_INCREMENT = 123;
CREATE TABLE Table2 (Id INT AUTO_INCREMENT PRIMARY KEY, 
                     Name VARCHAR(255), 
                     parentId INT) AUTO_INCREMENT = 456;
INSERT INTO Table1 VALUES (DEFAULT, 'Name 1');

SELECT * FROM Table1;


Id
Name


123
Name 1


INSERT INTO Table2 (Name, parentId)
SELECT 'Name 2', Id
FROM Table1
WHERE Name = 'Name 1';

SELECT * FROM Table2;

Records: 1  Duplicates: 0  Warnings: 0




Id
Name
parentId


456
Name 2
123