在sql中从单个select语句向两个表中插入数据

CREATE TABLE table1 (
    id INT,
    name VARCHAR(50),
    age INT
);

CREATE TABLE table2 (
    id INT,
    address VARCHAR(100),
    email VARCHAR(100)
);

INSERT INTO table1 (id, name, age)
SELECT id, name, age
FROM source_table;

INSERT INTO table2 (id, address, email)
SELECT id, address, email
FROM source_table;