1.基础查询
select * from student where id=1
2.排序:id降序
select * from student order by id desc
3.分组:每个年级的人数
select grade,count(*) from student group by grade
4.添加
insert into student(grade,name) values(2021,‘张三’)
5.更新
update student set name=‘李四’ where name=‘张三’
6.删除
delete student where name=‘李四’
Sql基础语法
最新推荐文章于 2024-09-23 07:43:29 发布