假设有一张表名为Student,信息如下:
Number | Name | Score |
1 | WangQi | 88 |
2 | LiSi | 66 |
1. 增 - 要求在该表中插入一行叫做ZhangSan的同学信息,分数为90:
insert into Student (Number,Name,Score) values (3,"ZhangSan",90)
2. 删 - 要求在该表中删除分数小于等于70的行:
delete from Student where Score<=70
3. 改 - 要求把姓名为LiSi的同学分数改为99:
update Student set Score=99 where Name="LiSi"
4. 查 - 要求查出中分数大于等于80的序号和分数信息:
select Number,Score from Student where Score>=80