如何向mysql表中插入字段

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

INSERT INTO students (name, age, grade) VALUES ('Alice', 20, 'A');

INSERT INTO students (name, age, grade) VALUES 
('Bob', 22, 'B'),
('Charlie', 21, 'A');

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

-- 错误示例
INSERT INTO students (name, age) VALUES ('David', '23'); -- age应为INT类型

-- 正确示例
INSERT INTO students (name, age) VALUES ('David', 23);

-- 使用INSERT IGNORE
INSERT IGNORE INTO students (id, name, age, grade) VALUES (1, 'Eve', 24, 'A');

-- 使用ON DUPLICATE KEY UPDATE
INSERT INTO students (id, name, age, grade) 
VALUES (1, 'Eve', 24, 'A') 
ON DUPLICATE KEY UPDATE name='Eve', age=24, grade='A';