|
Server IP : 172.16.15.8 / Your IP : 52.15.68.97 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/cngray/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
drop table BBUsers;
create table BBUsers(FName varchar(20), LName varchar(20), Username varchar(20) primary key, Password varchar(20), Year int, ContactInfo varchar(30));
insert into BBUsers values("John", "Wang", "jwang", "jwang12", 0, "jwang@comp.edu.edu");
insert into BBUsers values("Amy", "Smith", "asmith", "asmith12", 0, "asmith@comp.edu.edu");
insert into BBUsers values("Corey", "Gray", "cgray", "cgray12", 4, "cgray@comp.edu");
insert into BBUsers values("John", "Deer", "jdeer", "jdeer12", 3, "jdeer@comp.edu");
insert into BBUsers values("Mary", "Jane", "mjane", "mjane12", 4, "mjane@comp.edu");
insert into BBUsers values("Thomas", "Anderson", "tanderson", "tansderson12", 3, "tanderson@comp.edu");
insert into BBUsers values("Sarah", "Connor", "sconnor", "sconnor12", 4, "sconnor@comp.edu");
insert into BBUsers values("Guest", "User", "username", "password", -1, null);
select * from BBUsers;
drop table cgray;
create table cgray(Name varchar(20), Professor varchar(20), Courses varchar(20), A1 int, A2 int, A3 int, A4 int, A5 int, FinalGrade int);
insert into cgray values("Corey Gray", "Wang", "CS 310", null, null, null, null, null, 0);
insert into cgray values("null", "Smith", "MTH 172", null, null, null, null, null, 0);
select * from cgray;
drop table jdeer;
create table jdeer(Name varchar(20), Professor varchar(20), Courses varchar(20), A1 int, A2 int, A3 int, A4 int, A5 int, FinalGrade int);
insert into jdeer values("John Deer", "Wang", "CS 310", null, null, null, null, null, 0);
insert into jdeer values("null", "Wang", "CS 440", null, null, null, null, null, 0);
select * from jdeer;
drop table mjane;
create table mjane(Name varchar(20), Professor varchar(20), Courses varchar(20), A1 int, A2 int, A3 int, A4 int, A5 int, FinalGrade int);
insert into mjane values("Mary Jane", "Wang", "CS 440", null, null, null, null, null, 0);
insert into mjane values("null", "Wang", "CS 480", null, null, null, null, null, 0);
select * from mjane;
drop table tanderson;
create table tanderson(Name varchar(20), Professor varchar(20), Courses varchar(20), A1 int, A2 int, A3 int, A4 int, A5 int, FinalGrade int);
insert into tanderson values("Thomas Anderson", "Wang", "CS 480", null, null, null, null, null, 0);
insert into tanderson values("null", "Smith", "MTH 205", null, null, null, null, null, 0);
select * from tanderson;
drop table sconnor;
create table sconnor(Name varchar(20), Professor varchar(20), Courses varchar(20), A1 int, A2 int, A3 int, A4 int, A5 int, FinalGrade int);
insert into sconnor values("Sarah Connor", "Smith", "MTH 205", null, null, null, null, null, 0);
insert into sconnor values("null", "Smith", "MTH 172", null, null, null, null, null, 0);
select * from sconnor;