insert into 字段值
values值
-- 项目统计学生
create table course1(
Student int,
cname varchar(20),
age int,
gender char(1),
ddress varchar(40)
);
-- 不推荐
insert into course1(Student, cname,age,gender,ddress)
values (1,'小宋',20,'女','北京');
-- 推荐快捷
insert into course1 values (2,'小红',20,'女','北京');
insert into course1 values (3,'小兰',21,'女','北京');
insert into course1 values (4,'小李',21,'女','上海');
insert into course1 values (5,'小爱',21,'女','北京');
-- 指定