Sql基础语法
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=‘张三’
原创
2021-07-19 20:32:51 ·
57 阅读 ·
0 评论