MySQL 8.0

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

CREATE TABLE t1 (id INT PRIMARY KEY, val INT);
CREATE TABLE t2 (id INT PRIMARY KEY, val INT);
CREATE TABLE sequence (id INT AUTO_INCREMENT PRIMARY KEY);
CREATE TRIGGER tr_t1_bi BEFORE INSERT ON t1 
FOR EACH ROW 
BEGIN
    INSERT INTO sequence VALUES (DEFAULT);
    SET NEW.id = LAST_INSERT_ID();
END
CREATE TRIGGER tr_t2_bi BEFORE INSERT ON t2
FOR EACH ROW 
BEGIN
    INSERT INTO sequence VALUES (DEFAULT);
    SET NEW.id = LAST_INSERT_ID();
END
INSERT INTO t1 (val) VALUES (11), (22);
INSERT INTO t2 (val) VALUES (33);
INSERT INTO t2 (val) VALUES (44), (55);
INSERT INTO t1 (val) VALUES (66);
SELECT * FROM t1;
SELECT * FROM t2;

Records: 2  Duplicates: 0  Warnings: 0



Records: 2  Duplicates: 0  Warnings: 0




id
val


1
11

2
22

6
66




id
val


3
33

4
44

5
55