1.新增Sql的语法:
insert [into] 表名 [(列名)] values (值列表)
示例:新增姓名为张三的同学的信息
insert into student(sname) values('张三');
2.修改sql的语法:
update 表名 set 列名 = 更新值 [where 更新条件]
示例:修改李四同学的年龄为18岁
update student set sage='18' where sname='李四';
3.删除sql的语法:
delete [from] 表名 [where <删除条件>]
示例:删除名字为王五的同学的信息
delete from student where sname='王五';
4.查询sql的语法:
select <列名>
from <表名>
[where <查询条件表达式>]
[having <分组条件>]
[order by <排序的列名>[asc(正序)或desc(倒序)]默认是asc]
select * from grade
select * from grade where gradeId='1';
select * from grade having gradeId='1';
select * from grade order by gradeId
查询所有女学生并按一年级分组后学号降序排列
select * from student
where gender='女'
having gradeId='1'
order by studentNo desc