By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE t1 (id INT);
CREATE TABLE t2 LIKE t1;
INSERT INTO t1 VALUES (1), (2), (3);
INSERT INTO t2 SELECT * FROM t1;
SELECT * FROM t1; SELECT * FROM t2;
Records: 3 Duplicates: 0 Warnings: 0
Records: 3 Duplicates: 0 Warnings: 0
| id |
|---|
| 1 |
| 2 |
| 3 |
| id |
|---|
| 1 |
| 2 |
| 3 |
DELETE FROM t1 ORDER BY id ASC LIMIT 1;
DELETE FROM t2 ORDER BY id DESC LIMIT 1;
SELECT * FROM t1; SELECT * FROM t2;
| id |
|---|
| 2 |
| 3 |
| id |
|---|
| 1 |
| 2 |