Victoria Becu

Craft 3 insert statements to populate data

I made 3 insert statements and ran them on PHPMyAdmin (along with the rest of the code) to create sections of a class, their students, etc

  • December 16, 2016 at 9:35 PM
  • Visible to public
INSERT INTO `College` (  `Major` ,  `Department` ,  `College_Name` ,  `College_ID` ) 
VALUES ('Computer Engineering', 'Electrical and Computer Engineering', 'Engineering', 052);
 
INSERT INTO `Course`(`TA`, `Professor`, `Section`, `Course_Name`, `Course_ID`, `College_ID`) 
VALUES('Elon Musk', 'Charles Schultz', 042, 'CSC176', 032, 052);
 
INSERT INTO  `Student` (  `Major` ,  `Username` ,  `ID_#` ,  `Course_ID` ,  `College_ID` ) 
VALUES ('Computer Science',  'vbecu1', 1010105, 032, 052)