|
Server IP : 172.16.15.8 / Your IP : 3.137.169.56 Web Server : Apache System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.2.24 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0705) : /home/cchansen/../cngray/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
drop table Courses;
create table Courses(Course varchar(20), Prof varchar(20));
insert into Courses values("CS 310", "Wang");
insert into Courses values("CS 440", "Wang");
insert into Courses values("CS 480", "Wang");
insert into Courses values("MTH 205", "Smith");
insert into Courses values("MTH 172", "Smith");
select * from Courses;
drop table CS310;
create table CS310(Prof varchar(20), Student varchar(20), );
insert into CS310 values("Wang", "Corey Gray");
insert into CS310 values(null, "John Deer");
select * from CS310;
drop table CS440;
create table CS440(Prof varchar(20), Student varchar(20));
insert into CS440 values("Wang", "John Deer");
insert into CS440 values(null, "Mary Jane");
select * from CS440;
drop table CS480;
create table CS480(Prof varchar(20), Student varchar(20));
insert into CS480 values("Wang", "Mary Jane");
insert into CS480 values(null, "Thomas Anderson");
select * from CS480;
drop table MTH205;
create table MTH205(Prof varchar(20), Student varchar(20));
insert into MTH205 values("Smith", "Thomas Anderson");
insert into MTH205 values(null, "Sarah Connor");
select * from MTH205;
drop table MTH172;
create table MTH172(Prof varchar(20), Student varchar(20));
insert into MTH172 values("Smith", "Sarah Connor");
insert into MTH172 values(null, "Corey Gray");
select * from MTH172;