CollyneJumah
commented
8 months ago Another one to add new records :
-- INSERT DATA INSERT INTOenrollment (id,fullname,course,email,gender,phonenumber) VALUES (NULL, 'Amanda Nunes','AWS Solutions Architect ', 'anunes@ufc.com', 'Male', '012345 678910'), (NULL, 'Alexander Volkanovski', 'AWS Solutions Architect', 'avolkanovski@ufc.com', 'Male', '012345 678910'), (NULL, 'Khabib Nurmagomedov', 'Cloud DevOps', 'knurmagomedov@ufc.com','Female', '012345 678910'), (NULL, 'Kamaru Usman', 'Cloud DevOps', 'kusman@ufc.com', 'Male', '012345 678910'), (NULL, 'Israel Adesanya', 'AWS Cloud Developer', 'iadesanya@ufc.com','Female', '012345 678910'), (NULL, 'Henry Cejudo', 'AWS Solutions Architect', 'hcejudo@ufc.com', 'Female', '012345 678910'), (NULL, 'Valentina Shevchenko', 'AWS Solutions Architect', 'vshevchenko@ufc.com', 'Male', '012345 678910'), (NULL, 'Tyron Woodley', 'AWS Solutions Architect', 'twoodley@ufc.com','Male', '012345 678910'), (NULL, 'Rose Namajunas', 'AWS Cloud Developer', 'rnamajunas@ufc.com','Male', '012345 678910'), (NULL, 'Tony Ferguson', 'AWS Cloud Developer', 'tferguson@ufc.com', 'Male', '012345 678910'), (NULL, 'Jorge Masvidal', 'AWS Cloud Practitioner', 'jmasvidal@ufc.com', 'Female', '012345 678910'), (NULL, 'Nate Diaz', 'AWS Cloud Practitioner ', 'ndiaz@ufc.com', 'Male', '012345 678910'), (NULL, 'Conor McGregor', 'AWS Solutions Architect ', 'cmcGregor@ufc.com','Male', '012345 678910'), (NULL, 'Cris Cyborg', 'AWS Cloud Practitioner ', 'ccyborg@ufc.com', 'Male', '012345 678910'), (NULL, 'Tecia Torres', 'AWS Cloud Practitioner', 'ttorres@ufc.com', 'Male', '012345 678910'), (NULL, 'Ronda Rousey', 'AWS Cloud Practitioner ', 'rrousey@ufc.com','Female', '012345 678910'), (NULL, 'Holly Holm', 'AWS Solutions Architect', 'hholm@ufc.com', 'Male', '012345 678910'), (NULL, 'Joanna Jedrzejczyk', 'AWS Cloud Developer ', 'jjedrzejczyk@ufc.com','Male', '012345 678910');
@Amn8189 @Fiazee2012 here is the SQS Query to create a table inside database called school
CREATE TABLEschool.enrollment(idINT NOT NULL AUTO_INCREMENT ,fullnameVARCHAR(45) NOT NULL ,genderVARCHAR(45) NOT NULL ,emailVARCHAR(45) NOT NULL ,courseVARCHAR(45) NOT NULL,phonenumberVARCHAR(45) NOT NULL , PRIMARY KEY (id)) ENGINE = InnoDB;