增加数据

---插入数据(非数字要用引号包起来)
insert into my_student
values(1,'bc20200001','jimi','male'),
(1,'bc20200002','lili','female'),

----插入数据，指定字段列表
insert into my_student(number,sex,name,id)values
('bc20200003','li','female',3),
('bc20200004','com','female',4);

查看数据.png

查看数据

---查看所有数据
select * from my_student;
--查看指定字段、指定条件的数据
select id,number,sex,name, from my_student
where id = 1;--查看满足id为1的学生的信息

修改数据

---更新数据
update my_student set sex = 'female' where name='jimi';

删除数据

--删除数据
delete from my_student where sex='male';