时间戳

首页 > 解决方案 > 我该如何解决以下问题

mysql-workbench - 我该如何解决以下问题

问题描述

我正在执行此查询，即使我正在选择数据库并执行错误，我也会收到此错误。这是代码。

DROP TABLE IF EXISTS STUDENT;
DROP TABLE IF EXISTS CAMPUS;
DROP TABLE IF EXISTS SEMESTER;
DROP TABLE IF EXISTS ROOM;
DROP TABLE IF EXISTS GRADES;
DROP TABLE IF EXISTS COURSE;
DROP TABLE IF EXISTS INSTRUCTOR;
DROP TABLE IF EXISTS APPROVED_INSTRUCTOR;
DROP TABLE IF EXISTS CLASS;
DROP TABLE IF EXISTS STUDENT_GRADE;

CREATE TABLE STUDENT( STUDENT_ID INTEGER AUTO_INCREMENT NOT NULL PRIMARY KEY, Last_Name VARCHAR(30), First_Name VARCHAR(30), Address VARCHAR(40), ZIP VARCHAR(10), MAJOR VARCHAR(20), CLASS int(2), STATUS VARCHAR (20));

插入学生（姓氏、名字、地址、邮编、专业、班级、状态）值（'Morote','Italo','PO Box 619, 5808 Semper St.','32828','MATHEMATICS',2,'失败'）; 插入学生（姓氏、名字、地址、邮编、专业、班级、状态）值（'Martin','Yacky','313-6948 Nunc, Ave','36702','SPANISH',3,'SATISFACTORY' ); 插入学生（姓氏、名字、地址、邮政编码、专业、班级、状态）
VALUES('Yostin','Duglas','Ap #593-8291 Id St.','26151','BUSINESS',1,'SATISFACTORY'); 插入学生（姓氏、名字、地址、邮编、专业、班级、状态）值（'Dasti'、'Cosimel'、'328-4572 Elit Rd.'、'95886'、'SPANISH'、2、'FAILING' ); 插入学生（姓氏、名字、地址、邮编、专业、班级、状态）值（'Dixon','Steve','Ap #547-7314 Feugiat. Street','42756','PHIL',1,'失败'）; 插入学生（姓氏、名字、地址、邮编、专业、班级、状态）值（'Alfaro','Patricia','PO Box 977, 6922 Sed Street','52838','ENGLISH',1,'FAILING '); 插入学生（Last_Name、First_Name、Address、ZIP、MAJOR、CLASS、STATUS) VALUES('Farruco','Rose','Ap #179-4485 Lectus Road','10816','ENGLISH',3,'FAILING'); 插入学生（姓氏、名字、地址、邮编、专业、班级、状态）值（'Pope'、'Vector'、'Ap #878-2252 Curabitur Av.'、'53175'、'PHYSICS'、3、'满意的'）; 插入学生（姓氏、名字、地址、邮编、专业、班级、状态）值（'Los'、'Angeles'、'Ap #552-758 Convallis St.'、'56968'、'FINANCE'、3、'失败'）; 插入学生（姓氏、名字、地址、邮编、专业、班级、状态）值（'Diaz'、'Cameron'、'Ap #145-1961 Sed Street'、'63397'、'BUSINESS'、3、'SATISFACTORY '); 插入学生（Last_Name、First_Name、Address、ZIP、MAJOR、CLASS、STATUS) VALUES('Gonzalez','Andew','Ap #141-9425 In Road','87521','BUSINESS',4,'SATISFACTORY'); 插入学生（姓氏、名字、地址、邮编、专业、班级、状态）值（'Michael'、'Jordan'、'Ap #412-5802 Venenatis Rd.'、'77696'、'MARKETING'、2、'失败'）; 插入学生（姓氏、名字、地址、邮政编码、专业、班级、状态）值（'Chelerson'、'Scholy'、'911-8666 A Rd.'、'32829'、'CIS'、2、'SATISFACTORY' ); 插入学生（姓氏、名字、地址、邮编、专业、班级、状态）值（'Payton','Tanya','5759 Nec, Street','23461','SPANISH',3,'FAILING'）；插入学生（Last_Name、First_Name、Address、ZIP、MAJOR、CLASS、STATUS) VALUES('Jorge','Michael','Ap #642-7393 Ut, Ave','33186','PHIL',1,'SATISFACTORY'); 插入学生（姓氏、名字、地址、邮编、专业、班级、状态）值（'Cretiza','Noitus','8659 Arcu. Avenue','91267','PHYSICS',2,'FAILING'）；插入学生（姓氏、名字、地址、邮编、专业、班级、状态）值（'Delami'、'Oscar'、'3512 Pellentesque. St.'、'33481'、'数学'、4、'失败'） ; 插入学生（姓氏，名字，地址，邮政编码，专业，班级，状态）值（'Francisco'，'Zoeter'，'285-9157 Proin Road'，'98674'，'CS'，1，'SATISFACTORY'） ; 插入学生（姓氏、名字、地址、邮编、专业、班级、状态）值（' Cohen','Aurora','PO Box 957, 9450 Arcu Street','30350','PHIL',3,'FAILING'); 插入学生（姓氏，名字，地址，邮编，专业，班级，状态）值（'Black'，'Joshua'，'3655 Sed St.'，'95684'，'FRENCH'，2，'FAILING'）；插入学生（姓氏、名字、地址、邮编、专业、班级、状态）值（'Barber'、'Michael'、'875-9349 Magnis St.'、'66498'、'PSY'、4、'SATISFACTORY' ); 插入学生（姓氏、名字、地址、邮编、专业、班级、状态）值（'Preston'、'Inez'、'Ap #829-845 Nisi Av.'、'27404'、'PSY'、1、'失败'）; 插入学生（姓氏、名字、地址、邮编、专业、班级、状态）值（'Direz'、'Blaster'、' 439-1369 Cursus Av.','60644','MARKETING',2,'FAILING'); 插入学生（姓氏、名字、地址、邮政编码、专业、班级、状态）值（'Aiton'、'Valeria'、'7513 Vitae Street'、'61245'、'MARKETING'、2、'FAILING'）；

CREATE TABLE CAMPUS (CAMPUS_NAME VARCHAR(45) NOT NULL, Address VARCHAR(40), ZIP VARCHAR(10), PHONE_NO VARCHAR(20), UNIQUE(CAMPUS_NAME), PRIMARY KEY(CAMPUS_NAME));

INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('New York Campus','405-6298 In Street','62840','1-639-674-3520'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('Chicago','820-7808 Risus, Rd.','51852','1-824-430-8362'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('旧金山校区','505-182 Luctus, Ave','21345','1-460-439-2331'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('Seattle Campus','PO Box 215, 1469 Eu Rd.','52681','1-448-789-7971'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('Washington Campus','631-5139 Leo. St.','29402','1-282-625-5720'); 插入校园（CAMPUS_NAME，地址，ZIP, PHONE_NO) VALUES('洛杉矶校区','6161 Nostra, Road','83643','1-547-459-9473'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('Denver Campus','9309 Cras Road','23421','1-680-673-7298'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('Austin Campus','PO Box 878, 7621 Donec Road','73261','1-755-573-0468'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('Houston Campus','PO Box 406, 9600 Odio Ave','32802','1-721-423-4315'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('Detroit Campus','7574 Semper St.','21211','1-583-233-9026'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES(' 圣迭戈校区','6939 Ligula。圣','75022','1-941-394-7241'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('San Antonio Campus','7422 Vel Avenue','63763','1-604-359-7505'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('Memphis Campus','PO Box 328, 5280 Donec Rd.','75068','1-865-208-5487'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('Portland Campus','788-7924​​ Tellus. Street','75088','1-260-552-0600'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('Miami Campus','518-7627 Ac Avenue','89090','1-262-155-0231'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('Phoenix Campus',' 921-4825 Nullam Rd.','23117','1-324-211-7180​​'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('Dallas Campus','Ap #202-6418 Eleifend Ave','54674','1-663-374-3235'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('Atlanta Campus','927-3569 Id Road','71661','1-315-710-9509'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('San Jose Campus','8637 Ullamcorper Rd.','10001','1-224-161-4524'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('Las Vegas Campus','PO Box 169, 7139 Arcu Rd.','83588','1-789-125-9687'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('Indianapolis Campus','744-3904 Vulputate, Road', '37762','1-640-455-9785'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('Baltimore Campus','2849 At Ave','40882','1-299-696-4483'); INSERT INTO CAMPUS (CAMPUS_NAME, Address, ZIP, PHONE_NO) VALUES('Cleveland Campus','PO Box 785, 7330 Urna. St.','55794','1-789-114-1794'); 插入校园（CAMPUS_NAME、地址、邮编、电话号码）
VALUES('俄克拉荷马校区','172-3924 At Ave','31619','1-111-206-2900');

CREATE TABLE SEMESTER (SEMESTER_NAME ENUM('FALL', 'SPRING', 'SUMMER'));

如果存在房间级联，则丢弃表；

创建表室 ( Campus_Name VARCHAR(45), ROOM_NO VARCHAR(10), FACILITY VARCHAR(45), CAPACITY int(3) );

INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('New York Campus','6','Lloydminster',30); 插入房间（校园名称，房间号，设施，容量）值（'芝加哥'，'19'，'侵蚀'，32）；INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('旧金山校区','40','Cantalupo in Sabina',38); 插入房间（校园名称，房间号，设施，容量）值（'西雅图'，'40'，'Assiniboia'，25）；INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('Washington Campus','23','Kessenich',42); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('洛杉矶校区','47','Stony Plain',46); 插入房间（Campus_Name,ROOM_NO,FACILITY,CAPACITY）VALUES（'Denver Campus',' 29','乌尔姆',44); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('Austin Campus','46','Bielefeld',39); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('Houston Campus','37','Georgia',38); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('Detroit Campus','29','Lummen',30); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('圣地亚哥校区','3','Pak Pattan',33); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('圣安东尼奥校区','37','南珀斯',27); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('Memphis Campus','35','Meeuwen',14); 插入房间（校园名称，房间号，设施，容量）值（' 波特兰校区','20','贝尔卡拉',23); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('迈阿密校区','5','Jette',27); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('Phoenix Campus','24','Milwaukee',18); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('Dallas Campus','23','Afsnee',39); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('San Jose Campus','50','Stamford',26); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('Dallas Campus','23','Afsnee',39); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('San Jose Campus','50','Stamford',26); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('Dallas Campus','23','Afsnee',39); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('San Jose Campus','50','Stamford',26);
INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('Atlanta Campus','5','Stamford',21); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('Las Vegas Campus','40','Morgex',11); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('Indianapolis Campus','1','Montague',21); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('Baltimore Campus','40','Cumberland',21); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('Cleveland Campus','4','Harrison Hot Springs',32); INSERT INTO ROOM(Campus_Name,ROOM_NO,FACILITY,CAPACITY) VALUES('Oklahoma Campus','10','Sainte-Ode',15);

创建表等级（等级枚举（'A'，'B'，'C'，'D'，'F'，'I'，'W'））；

创建表课程（ Course_No Varchar(10) NOT NULL, Course_Name Varchar(25), CreditHours int(2), UNIQUE(COURSE_NO), PRIMARY KEY(COURSE_NO) ）；

INSERT INTO COURSE(Course_No,Course_Name,CreditHours)
VALUES('1043','TECH121',1); 插入课程（Course_No，Course_Name，CreditHours）
值（'1006'，'Psy101'，3）；INSERT INTO COURSE(Course_No,Course_Name,CreditHours)
VALUES('1696','Psy101',2); 插入课程(Course_No,Course_Name,CreditHours)
VALUES('1291','HUM234',2); 插入课程（Course_No，Course_Name，CreditHours）
值（'1841'，'Psy101'，3）；插入课程(Course_No,Course_Name,CreditHours)
VALUES('1697','ELE102',2); 插入课程（Course_No，Course_Name，CreditHours）
值（'1292'，'LIT405'，2）；插入课程（Course_No，Course_Name，CreditHours）
值（'1698'，' ELE101',3); 插入课程（Course_No,Course_Name,CreditHours）
值（'1255'，'Math101'，2）；插入课程（Course_No,Course_Name,CreditHours)
VALUES('1842','TECH121',3); 插入课程（Course_No,Course_Name,CreditHours）
值（'1010','Psy101',3）; 插入课程(Course_No,Course_Name,CreditHours)
VALUES('1810','Psy101',1); 插入课程(Course_No,Course_Name,CreditHours)
VALUES('1044','Math131',3); 插入课程(Course_No,Course_Name,CreditHours)
VALUES('1293','Math131',1); 插入课程(Course_No,Course_Name,CreditHours)
VALUES('1528','CS234',2); 插入课程（Course_No，Course_Name，CreditHours）
值（'1324'，'PHY345'，2）；插入课程（Course_No，Course_Name，
CreditHours) VALUES('1045','Math101',1); 插入课程（Course_No,Course_Name,CreditHours）
值（'1659'，'CS211'，1）；插入课程(Course_No,Course_Name,CreditHours)
VALUES('1294','PHY345',3); 插入课程（Course_No,Course_Name,CreditHours）
值（'1144','Psy101',2); 插入课程（Course_No,Course_Name,CreditHours）
值（'1843','ELE102',1）; 插入课程（Course_No,Course_Name,CreditHours）
值（'1569','Math101',3）; INSERT INTO COURSE(Course_No,Course_Name,CreditHours)
VALUES('1811','ENG304',3);

CREATE TABLE INSTRUCTOR ( INSTRUCTOR_ID VARCHAR(10) NOT NULL, LAST_NAME VARCHAR(30), FIRST_NAME VARCHAR(20), ADDRESS VARCHAR(40), ZIP VARCHAR(10), OFFICE_NO VARCHAR(10), UNIQUE(INSTRUCTOR_ID), PRIMARY KEY( INSTRUCTOR_ID));

INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('400','Thane','Puckett','PO Box 895, 191 Erat Rd.','53841','30'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('737','Jared','Tate','Ap #177-1334 Faucibus St.','88675','21'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('640','Yuli','Hurst','Ap #799-5088 Scelerisque St.','26162','12'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('256','Micah','Pace','PO Box 638, 2109 Adipiscing Rd.','40665','12'); 插入教员（教员 ID，FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('741','Kasper','Duran','565-193 Nunc Avenue','55756','17'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('653','Dolan','Moore','3869 Cursus Road','37236','10'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('688','Ciaran','Blackwell','Ap #754-6723 Faucibus Rd.','83479','17'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('940','Kennedy','Fowler','749-1142 Non Av.','98172','22'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('499',' Devin','Acosta','7613 Vel Road','93686','19'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('280','Driscoll','Justice','PO Box 113, 3705 Ut, St.','69877','23') ; INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('937',',Cairo','Donaldson','6470 Adipiscing Rd.','63032','26'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('415','Hammett','Glenn','262-2645 At Rd.','84839','22'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('549','Elliott','Donaldson','5470 Dolor. Street',' 62489','23'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('639','Lamar','Robles','5719 Consectetuer St.','20213','25'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('767','Colin','Riley','PO Box 114, 1663 Ultrices. Street','23254','16'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('344','Richard','Thornton','PO Box 931, 8187 Lacinia. St.','29349','23') ; INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('581','Raymond','Snow','1032 Est St.','66699','20'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('474','Nero','Rhodes','6050 Ante Ave','37967','28'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('534','Tate','Carr','PO Box 213, 1879 Purus. Ave','19803','15'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('521','Lance','Waters','656-7361 Conubia Ave','6315','26'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('413','Abbot','Ross','PO Box 859, 9379 Sed Avenue','45051','25'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS, ZIP,OFFICE_NO) VALUES('891','Dylan','福布斯','225-3164 Fermentum Ave','65642','26'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('879','Arsenio','Singleton','505-6318 Vel, St.','97288','10'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('350','Thor','Copeland','Ap #816-3443 Magna. Avenue','43447','4'); 10'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('350','Thor','Copeland','Ap #816-3443 Magna. Avenue','43447','4'); 10'); INSERT INTO INSTRUCTOR(Instructor_ID,FIRST_NAME,LAST_NAME,ADDRESS,ZIP,OFFICE_NO) VALUES('350','Thor','Copeland','Ap #816-3443 Magna. Avenue','43447','4');

CREATE TABLE APPROVED_INSTRUCTOR ( Instructor_ID VARCHAR(10) NOT NULL, Course_No VARCHAR(10) NOT NULL );

INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('400','1044'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('737','1528'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('640','1324'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('256','1842'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('741','1006'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('653','1431'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('688','1291'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('940','1810'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('499',' 1841'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('280','1211'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('937','1144'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('415','1255'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('549','1033'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('639','1881'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('767','1526'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('344','1249'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('581','1659'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('474', '1298'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('534','1569'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('521','1192'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('413','1722'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('891','1511'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('879','1696'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('350','1844'); Course_No) VALUES('413','1722'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('891','1511'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('879','1696'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('350','1844'); Course_No) VALUES('413','1722'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('891','1511'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('879','1696'); INSERT INTO APPROVED_INSTRUCTOR(Instructor_ID, Course_No) VALUES('350','1844');

创建表类（Class_id VARCHAR(10) NOT NULL，Course_No VARCHAR(10) NOT NULL，部分 VARCHAR(10)，学期 Varchar(15)，年 VARCHAR(4)，Instructor_ID VARCHAR(10) NOT NULL，校园 Varchar(15 ), Room_No VARCHAR(10), Start_Date 日期, Start_Time 时间, UNIQUE (CLass_id), PRIMARY KEY (Class_id) );

插入课程（Class_ID，Course_No，Semester，Instructor_ID，Start_Date，Start_Time，Section，Year）值（'12408'，'1044'，'Fall'，'499'，'2014-10-08'，'8:00 ','10','2014'); 插入课程（Class_ID,Course_No,Semester,Instructor_ID,Start_Date,Start_Time,Section,Year）值（'15716','1006','Other','639','2014-10-08','8:00 ','17','2014'); 插入课程（Class_ID,Course_No,Semester,Instructor_ID,Start_Date,Start_Time,Section,Year） VALUES('12525','1291','Other','767','2014-10-08','8:00' ','18','2014'); 插入课程（Class_ID，Course_No，Semester，Instructor_ID，Start_Date，Start_Time，Section，Year）值（'16500'，'1696'，'Winter'，'937'，' 2015-01-03','8:00','19','2014'); 插入课程（Class_ID,Course_No,Semester,Instructor_ID,Start_Date,Start_Time,Section,Year）值（'19047','1291','Winter','280','2015-01-03','8:00 ','14','2014'); 插入课程（Class_ID,Course_No,Semester,Instructor_ID,Start_Date,Start_Time,Section,Year） VALUES('12587','1841','Other','280','2014-08-10','8:00' ','15','2014'); 插入课程（Class_ID,Course_No,Semester,Instructor_ID,Start_Date,Start_Time,Section,Year） VALUES('17106','1696','Other','400','2014-08-10','8:00' ','10','2014'); 插入课程（Class_ID，Course_No，学期，Instructor_ID，Start_Date，Start_Time，Section，Year）VALUES（' 14331','1291','其他','413','2014-08-10','8:00','14','2014'); INSERT INTO CLASS(Class_ID,Course_No,Semester,Instructor_ID,Start_Date,Start_Time,Section,Year) VALUES('17246','1696','Summer','640','2015-06-12','8:00 ','12','2014'); 插入课程（Class_ID,Course_No,Semester,Instructor_ID,Start_Date,Start_Time,Section,Year）值（'17092','1255','Summer','639','2015-06-12','8:00 ','10','2014'); 插入课程（Class_ID,Course_No,Semester,Instructor_ID,Start_Date,Start_Time,Section,Year）值（'14169','1842','Fall','344','2014-08-10','8:00 ','13','2014'); 插入课程（Class_ID，Course_No，学期，Instructor_ID,Start_Date,Start_Time,Section,Year) VALUES('13062','1006','Winter','879','2015-01-03','8:00','12','2014') ; INSERT INTO CLASS(Class_ID,Course_No,Semester,Instructor_ID,Start_Date,Start_Time,Section,Year) VALUES('17267','1810','Summer','640','2015-06-12','8:00 ','15','2014'); 插入课程（Class_ID，Course_No，Semester，Instructor_ID，Start_Date，Start_Time，Section，Year）值（'15415'，'1044'，'Summer'，'549'，'2015-06-12'，'8:00 ','15','2014'); 插入课程（Class_ID，Course_No，Semester，Instructor_ID，Start_Date，Start_Time，Section，Year）值（'11386'，'1291'，'Fall'，'767'，'2014-08-10'，'8:00 ','10', '2014'); 插入课程（Class_ID,Course_No,Semester,Instructor_ID,Start_Date,Start_Time,Section,Year）值（'14972','1528','Other','937','2014-08-10','8:00' ','17','2014'); 插入类（Class_ID,Course_No,Semester,Instructor_ID,Start_Date,Start_Time,Section,Year）值（'15009','1324','Fall','256','2014-08-10','8:00 ','11','2014'); 插入课程（Class_ID,Course_No,Semester,Instructor_ID,Start_Date,Start_Time,Section,Year）值（'18265','1044','Winter','415','2015-01-03','8:00 ','12','2014'); 插入课程（Class_ID，Course_No，Semester，Instructor_ID，Start_Date，Start_Time，Section，Year）VALUES（'16415'，'1659'，'Fall'，'474','2014-08-10','8:00','14','2014'); 插入课程（Class_ID，Course_No，Semester，Instructor_ID，Start_Date，Start_Time，Section，Year）值（'19464'，'1291'，'Fall'，'521'，'2014-08-10'，'8:00 ','18','2014'); 插入课程（Class_ID,Course_No,Semester,Instructor_ID,Start_Date,Start_Time,Section,Year） VALUES('12433','1144','Summer','415','2015-06-12','8:00 ','10','2014'); 插入课程（Class_ID，Course_No，Semester，Instructor_ID，Start_Date，Start_Time，Section，Year）值（'19175'，'1842'，'Winter'，'534'，'2015-01-03'，'8:00 ','10','2014'); 插入课程（Class_ID，Course_No，学期，Instructor_ID，Start_Date，Start_Time，Section,Year) VALUES('19864','1569','Summer','280','2015-06-12','8:00','14','2014'); 插入课程（Class_ID,Course_No,Semester,Instructor_ID,Start_Date,Start_Time,Section,Year）值（'17022','1810','Other','940','2014-08-10','8:00' ','15','2014');

CREATE TABLE STUDENT_GRADE ( Student_ID MEDIUMINT NOT NULL AUTO_INCREMENT, Class_ID VARCHAR(10), Student_Grade ENUM('A','B','C','D','F','I','W'), 主键（学生卡） ）;

犯罪;

显示表格；

这是错误消息我收到 DROP TABLE IF EXISTS STUDENT 错误代码：1046。未选择数据库 通过在侧边栏中的 SCHEMAS 列表中双击其名称来选择要使用的默认数据库。

谢谢，文卡特

标签： mysql-workbench

解决方案

您应该指定要使用的数据库；

  USE db_name;

推荐阅读