DML插入字段

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,'女','北京');
-- 指定

INSERT INTO course1(cname ,gender,ddress )VALUES('小赵','男','上海');