mysql语句 插入

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

INSERT INTO table_name (column1, column2, column3, ...)
VALUES 
    (value1, value2, value3, ...),
    (value4, value5, value6, ...),
    ...

INSERT INTO table_name1 (column1, column2, ...)
SELECT column1, column2, ...
FROM table_name2;

CREATE TABLE students (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    age INT
);

INSERT INTO students (id, name, age) VALUES (1, 'Alice', 20);

INSERT INTO students (id, name, age) VALUES 
    (2, 'Bob', 22),
    (3, 'Charlie', 21);

INSERT INTO students (id, name, age)
SELECT id, name, age FROM new_students;