mysql中如何写入数据

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

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

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

UPDATE students
SET age = 21
WHERE id = 1;

-- 使用INSERT IGNORE忽略冲突
INSERT IGNORE INTO students (id, name, age)
VALUES (1, '张三', 20);

-- 使用REPLACE INTO替换冲突记录
REPLACE INTO students (id, name, age)
VALUES (1, '张三', 21);

-- 先查询确认是否存在id为1的记录
SELECT * FROM students WHERE id = 1;

-- 如果存在，再执行更新操作
UPDATE students
SET age = 21
WHERE id = 1;