1.数据的增加
- 全列插入:值和表的字段顺序一一对应
insert into students values (1,'张三',20,1,1);
- 指定列插入:值和列一一对应
insert into students (name,gender,class_id) values ('大乔',4,2);
- 多行插入,批量插入:values间用 , 隔开
insert into students (name,gender) values ('小乔',4),('周瑜',2);
2.数据的删除
delete from students where id = 2; # 用where做限定条件
3.数据的更改—update
update students set age = 26 where id = 2;
4.数据的查询—select
- 查询所有字段数据
select * from students;
- 查询指定字段数据
select name,gender from students; # 多字段用逗号隔开
- 使用 as 给字段起别名(用得少,仅作用于当前语句)
select name as 名字, gender as 性别 from students;
select name 名字 ,gender 性别 from students;
- 跨表查询
select students.name, c