一、SQL语句------->>添加表
***注:Oracle中,SQL语句不区分大小写。
----------------------------------学生表
create table student
(
stuid number not null,
stuname nvarchar2(20),
stusex nvarchar2(1),
stuage number
);
----------------------------------教师表
create table teacher
(
teaid number not null,
teaname nvarchar2(20),
teasex nvarchar2(1),
teaage number
);
----------------------------------科目表
create table subject
(
subid number not null,
subname nvarchar2(50),
teaid number
);
----------------------------------成绩表
create table score
(
scoid number not null,
grade number,
stuid number,
subid number
);
二、SQL语句------->>删除表单所有信息
delete from student;
delete from teacher;
delete from subject;
delete from score;
三、SQL语句------->>删除整张表
***注:不常用,小心从删库到跑路 === ^=^=== 一般都会提前备份。
drop student;
drop teacher;
drop subject;
drop score;
四、SQL语句------->>添加表单信息
----------------添加学生信息
insert into student(stuid,stuname,stusex,stuage)values(1001,'王川','男',22);
insert into student(stuid,stuname,stusex,stuage)values(1002,'惠丽丽','女',20);
----------------添加教师信息
insert into teacher(teaid,teaname,teasex,teaage)values(2001,'董香','女',44);
insert into teacher(teaid,teaname,teasex,teaage)values(2002,'东方少琴','女',38);
----------------添加科目信息
insert into subject(subid,subname,teaid)values(