yudisentosa
commented
3 years ago facility_id -> should be id not facility name add (,) before creating new syntax
Closed yoance closed 3 years ago
yudisentosa
commented
3 years ago facility_id -> should be id not facility name add (,) before creating new syntax
DROP TABLE IF EXISTS class_facility; CREATE TABLE class_facility( class_id VARCHAR(6) NOT NULL ,facility_id VARCHAR(6) NOT NULL ,effective_date DATE NOT NULL ,PRIMARY KEY(class_id,effective_date) ); INSERT INTO class_facility(class_id,facility_id,effective_date) VALUES ('10IPA1','FAC006','2017-07-03'); INSERT INTO class_facility(class_id,facility_id,effective_date) VALUES ('10IPS1','FAC007','2017-07-03'); INSERT INTO class_facility(class_id,facility_id,effective_date) VALUES ('11IPA1','FAC008','2017-07-03'); INSERT INTO class_facility(class_id,facility_id,effective_date) VALUES ('11IPS1','FAC009','2017-07-03'); INSERT INTO class_facility(class_id,facility_id,effective_date) VALUES ('12IPA1','FAC010','2017-07-03'); INSERT INTO class_facility(class_id,facility_id,effective_date) VALUES ('12IPS1','FAC011','2017-07-03');