create table student ( id int, sn int comment "学号", name varchar(20) comment "姓名", qq_mail varchar(20) comment "qq 邮箱" );
1单行数据 + 全列插入
– 插入两条记录,value_list 数量必须和定义表的列的数量及顺序一致
insert into student values (100, 10000, ‘唐三藏’, NULL);
insert into student values(101, 10001, ‘孙悟空’, ‘11111’);
2 多行数据 + 指定列插入
– 插入两条记录,value_list 数量必须和指定列数量及顺序一致
insert into student (id, name, sn) values (102, ‘曹孟德’, 20001),(103, ‘孙仲谋’, 20002);
select * from student;
案例:
– 创建考试成绩表
create table exam_result (
id int,
name varchar(200),
chinese double,
math double,
english double
);
– 插入测试数据
insert into exam_result values
(1, '唐三藏', 67, 98, 56),
(2, '孙悟空', 87.5, 78, 77),
(3, '猪悟能', 88, 98.5, 90),
(4, '曹孟德', 82, 84, 67),
(5, '刘玄德', 55.5, 85, 45),
(6, '孙权', 70, 73, 78.5),
(7, '宋公明', 75, 65, 30);