mysql中插入数据库

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

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

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

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

INSERT INTO table_name (column1, column2, column3, ...)
SELECT column1, column2, column3, ...
FROM another_table
WHERE condition;

INSERT INTO student_grades (student_id, grade)
SELECT id, final_grade
FROM students
WHERE final_grade > 85;

-- 使用INSERT IGNORE
INSERT IGNORE INTO students (id, name, age)
VALUES (1, 'Alice', 20);

-- 使用REPLACE INTO
REPLACE INTO students (id, name, age)
VALUES (1, 'Alice', 20);

-- 修改列的定义
ALTER TABLE students MODIFY COLUMN name VARCHAR(50);