从查询结果填充表(mysql)

SELECT name, age FROM users;

CREATE TABLE new_table_name (
    column1 datatype1,
    column2 datatype2,
    column3 datatype3,
    ...
);

CREATE TABLE user_info (
    name VARCHAR(255),
    age INT
);

INSERT INTO new_table_name (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM existing_table_name
WHERE some_condition;

INSERT INTO user_info (name, age)
SELECT name, age
FROM users;