SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE FACULTY ( FacultyID INT, FacultyName varchar(255), PRIMARY KEY (FacultyID) ); CREATE TABLE QUALIFIED ( FacultyID INT, CourseID INT, DateQualified varchar(255), PRIMARY KEY (CourseID, FacultyID) REFERENCES FACULTY(FacultyID), ); INSERT INTO FACULTY(FacultyID, FacultyName) VALUES(12143, 'Birkin'), (3467, 'Berndt'), (4756, 'Collins') INSERT INTO QUALIFIED(CourseID, DateQualified) VALUES('ISM 3112', '092011'),
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear