PHPize Online / SQLize Online  /  SQLtest Online

-- CREATE TABLES CREATE TABLE classes ( id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, className VARCHAR(16) NOT NULL, instructor VARCHAR(16) NOT NULL ); CREATE TABLE students ( id INT NOT NULL AUTO_INCREMENT, firstName VARCHAR(30) NOT NULL, lastName VARCHAR(255) NOT NULL, age INT, email VARCHAR(255) UNIQUE, classId INT, PRIMARY KEY (id), FOREIGN KEY (classId) REFERENCES classes(id) ON DELETE CASCADE ); -- INSERT DATA INSERT INTO classes (className, instructor) VALUES ('React', 'Anna Sfairo'), ('Express', 'Zoe Laventhol'); INSERT INTO `students` (firstName, lastName, email, age, classId) VALUES ('Lillian', 'Az', 'laz@codeop.tech', 32, 2), ('Niamh', 'Doyle', 'ndoyle@codeop.tech', 43, 1), ('Sian', 'Fairley', 'sfairley@codeop.tech', 42, 1), ('Jen', 'Hansonify', 'jhansonify@codeop.tech', 18, 2), ('Lethabo', 'Ndumo', 'lndumo@codeop.tech', 54, 2), ('Rebecca', 'Lupton', 'rlupton@codeop.tech', 27, 2), ('Larissa', 'Hernandez', 'lhernandez@codeop.tech', 31, 2), ('Elis', 'Matlik', 'ematlik@codeop.tech', 30, 1), ('Veronica', 'Viscardi', 'vviscardi@codeop.tech', 32, 2), ('Maria Carolina', 'Rinaldi', 'mcrinaldi@codeop.tech', 29, 2);