数据库作业

第一题

1.有一新记录（小王 13254748547 高中毕业2007-05-06），请用SQL语句新增至表中。

CREATE TABLE `User`(
	id int(12) PRIMARY KEY,
	Name varchar(10),
	Tel varchar(20),
	Content VARCHAR(10),
	Date date
	
);

insert User (id,Name,Tel,Content,Date) VALUES (1,"张三","13333663344","大专毕业","2006-01-01");
insert User (id,Name,Tel,Content,Date) VALUES (2,"张四","13612312331","本科毕业","2006-10-15");
insert User (id,Name,Tel,Content,Date) VALUES (3,"小明","13905333221","中专毕业","2006-10-15");
insert user (id,name,tel,content,date) VALUES (4,"小王","13254748547","高中毕业","2007-05-06");

2.请用 SQL 语句，把张三的时间更新为当前系统时间。

update user set date = SYSDATE() where name = "张三";

3.请写出删除姓名为张四的全部记录。

DELETE from user where name = "张四";

第二题
表名 student_score

1.用一条 SQL 语句，查询出每门课都大于 80 分的学生姓名。

CREATE