零基础看Java优学网MySQL插入数据课：轻松学会数据库增删改查，快速上手项目开发

INSERT INTO 表名 (字段1, 字段2) VALUES (值1, 值2);

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

INSERT INTO students (name, email, age) VALUES ('张三', 'zhangsan@example.com', 20);

-- 假设id=1的记录已存在 INSERT INTO users (id, name) VALUES (1, '张三'); -- 这里会报错：Duplicate entry '1' for key 'PRIMARY'

-- 将活跃用户复制到新表 INSERT INTO active_users (id, name, email) SELECT id, name, email FROM users WHERE last_login_date > '2024-01-01';

-- 最简单的插入语句 INSERT INTO users (name, email) VALUES ('李四', 'lisi@example.com');