Java语言程序设计(数据库编程）

以下SQL语句基于MySQL数据库实现：

1，在数据库中建立一个表，表名为学生，其结构为：学号、姓名、性别、年龄、成绩。

create table student
(
num char(4),
name char(10),
sex char(6),
age int,
score float
);

2，在学生表中输入4条记录

insert into student values ('0001','Susan','Female',19,89);
insert into student values ('0002','Merry','Female',20,87);
insert into student values ('0003','Tom','Male',18,44);
insert into student values ('0004','Jack','Male',20,90);

3，将每人的成绩增加10%

update student set score = score + score*0.1;

4，将每条记录按照成绩由大到小的顺序显示到屏幕上

select * from student order by score desc;

5，删除成绩不及格的学生记录

delete from student where score < 60;

update student set score=score+100*10% 每人的成绩增加10%
select * from student order by score 每条记录按照成绩由大到小的顺序
delete from student where score<60 删除成绩不及格的学生记录

上面有点错误
update student set score=score*1.1
select * from student order by score desc 后面加desc是降序排列，即由大到小
delete from student where score<60