yudisentosa
commented
3 years ago add a comma (,) when inserting other foreign keys change date data type into date before that change the date dataset and it is important to use the specific template (YYYY-MM-DD)
DROP TABLE IF EXISTS exam_schedule; CREATE TABLE exam_schedule( exam_id VARCHAR(9) NOT NULL PRIMARY KEY ,period_id VARCHAR(4) NOT NULL ,date VARCHAR(10) NOT NULL ,FOREIGN KEY (exam_id) REFERENCES examination(exam_id) ,FOREIGN KEY (period_id) REFERENCES period(period_id) ); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1BIN10','P001','12/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1BIG10','P001','13/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1MAN10','P001','14/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1PKN10','P001','15/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1PAK10','P001','16/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1OLG10','P001','19/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1MDS10','P001','20/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1MTK10','P002','12/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1BIO10','P002','13/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1KIM10','P002','14/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1FIS10','P002','15/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1EKO10','P002','16/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1SEJ10','P002','19/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1GEO10','P002','20/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1BIN11','P001','12/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1BIG11','P001','13/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1MAN11','P001','14/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1PKN11','P001','15/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1PAK11','P001','16/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1OLG11','P001','19/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1MDS11','P001','20/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1MTK11','P002','12/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1BIO11','P002','13/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1KIM11','P002','14/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1FIS11','P002','15/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1EKO11','P002','16/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1SEJ11','P002','19/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1GEO11','P002','20/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1BIN12','P001','12/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1BIG12','P001','13/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1MAN12','P001','14/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1PKN12','P001','15/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1PAK12','P001','16/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1OLG12','P001','19/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1MDS12','P001','20/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1MTK12','P002','12/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1BIO12','P002','13/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1KIM12','P002','14/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1FIS12','P002','15/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1EKO12','P002','16/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1SEJ12','P002','19/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS1GEO12','P002','20/10/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1BIN10','P001','07/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1BIG10','P001','08/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1MAN10','P001','09/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1PKN10','P001','10/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1PAK10','P001','11/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1OLG10','P001','14/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1MDS10','P001','15/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1MTK10','P002','07/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1BIO10','P002','08/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1KIM10','P002','09/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1FIS10','P002','10/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1EKO10','P002','11/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1SEJ10','P002','14/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1GEO10','P002','15/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1BIN11','P001','07/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1BIG11','P001','08/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1MAN11','P001','09/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1PKN11','P001','10/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1PAK11','P001','11/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1OLG11','P001','14/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1MDS11','P001','15/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1MTK11','P002','07/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1BIO11','P002','08/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1KIM11','P002','09/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1FIS11','P002','10/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1EKO11','P002','11/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1SEJ11','P002','14/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1GEO11','P002','15/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1BIN12','P001','07/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1BIG12','P001','08/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1MAN12','P001','09/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1PKN12','P001','10/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1PAK12','P001','11/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1OLG12','P001','14/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1MDS12','P001','15/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1MTK12','P002','07/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1BIO12','P002','08/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1KIM12','P002','09/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1FIS12','P002','10/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1EKO12','P002','11/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1SEJ12','P002','14/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS1GEO12','P002','15/12/2020'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2BIN10','P001','08/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2BIG10','P001','09/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2MAN10','P001','10/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2PKN10','P001','11/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2PAK10','P001','12/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2OLG10','P001','15/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2MDS10','P001','16/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2MTK10','P002','08/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2BIO10','P002','09/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2KIM10','P002','10/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2FIS10','P002','11/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2EKO10','P002','12/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2SEJ10','P002','15/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2GEO10','P002','16/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2BIN11','P001','08/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2BIG11','P001','09/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2MAN11','P001','10/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2PKN11','P001','11/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2PAK11','P001','12/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2OLG11','P001','15/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2MDS11','P001','16/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2MTK11','P002','08/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2BIO11','P002','09/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2KIM11','P002','10/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2FIS11','P002','11/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2EKO11','P002','12/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2SEJ11','P002','15/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2GEO11','P002','16/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2BIN12','P001','08/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2BIG12','P001','09/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2MAN12','P001','10/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2PKN12','P001','11/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2PAK12','P001','12/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2OLG12','P001','15/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2MDS12','P001','16/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2MTK12','P002','08/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2BIO12','P002','09/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2KIM12','P002','10/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2FIS12','P002','11/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2EKO12','P002','12/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2SEJ12','P002','15/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UTS2GEO12','P002','16/03/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2BIN10','P001','24/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2BIG10','P001','25/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2MAN10','P001','26/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2PKN10','P001','27/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2PAK10','P001','28/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2OLG10','P001','31/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2MDS10','P001','01/06/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2MTK10','P002','24/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2BIO10','P002','25/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2KIM10','P002','26/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2FIS10','P002','27/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2EKO10','P002','28/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2SEJ10','P002','31/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2GEO10','P002','01/06/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2BIN11','P001','24/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2BIG11','P001','25/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2MAN11','P001','26/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2PKN11','P001','27/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2PAK11','P001','28/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2OLG11','P001','31/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2MDS11','P001','01/06/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2MTK11','P002','24/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2BIO11','P002','25/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2KIM11','P002','26/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2FIS11','P002','27/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2EKO11','P002','28/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2SEJ11','P002','31/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2GEO11','P002','01/06/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2BIN12','P001','24/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2BIG12','P001','25/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2MAN12','P001','26/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2PKN12','P001','27/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2PAK12','P001','28/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2OLG12','P001','31/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2MDS12','P001','01/06/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2MTK12','P002','24/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2BIO12','P002','25/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2KIM12','P002','26/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2FIS12','P002','27/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2EKO12','P002','28/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2SEJ12','P002','31/05/2021'); INSERT INTO exam_schedule(exam_id,period_id,date) VALUES ('UAS2GEO12','P002','01/06/2021');