mysql中怎样插入

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

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'),
    ('David', 19, 'C');

INSERT INTO students
VALUES (NULL, 'Eve', 23, 'A');

-- 错误示例
INSERT INTO students (name, age, grade)
VALUES ('Frank', '25', 'B'); -- age 应该是 INT 类型，而不是 VARCHAR

-- 正确示例
INSERT INTO students (name, age, grade)
VALUES ('Frank', 25, 'B');

-- 错误示例
INSERT INTO students (id, name, age, grade)
VALUES (1, 'Grace', 24, 'A'); -- id 1 已经存在

-- 正确示例
INSERT INTO students (name, age, grade)
VALUES ('Grace', 24, 'A'); -- 让 id 自动递增

-- 假设有一个唯一约束在 name 列上
ALTER TABLE students ADD UNIQUE (name);

-- 错误示例
INSERT INTO students (name, age, grade)
VALUES ('Alice', 20, 'A'); -- Alice 已经存在

-- 正确示例
INSERT INTO students (name, age, grade)
VALUES ('Grace', 24, 'A'); -- 确保 name 是唯一的