Create Table SQL
CREATE TABLE tblFormUVMTV(
pmkSurveyID INT AUTO_INCREMENT PRIMARY KEY,
fldFirstName VARCHAR(25),
fldLastName VARCHAR(60),
fldIdea VARCHAR(200),
fldPost tinyint(1),
fldHelp tinyint(1),
fldJoin tinyint(1),
fldTime VARCHAR(5),
fldUVM VARCHAR(4),
fldEmail VARCHAR(60)
)
INSERT INTO tblFormUVMTV
(fldFirstName, fldLastName, fldIdea, fldPost, fldHelp, fldJoin, fldTime, fldUVM, fldEmail)
VALUES('Anja', 'Samsom', 'Fun video', 0, 1, 0, 'no', 'yesS', 'anjavt14@gmail.com')
INSERT INTO tblContact
(fldFirstName, fldLastName, fldPosition, fldEmail, fldGradYear)
VALUES('Adalia', 'Williams', 'Station Manager', 'Adalia.Williams@uvm.edu', 2023),
('Mac', 'Weaver', 'Program Director', ' mmweaver@uvm.edu', 2023),
('Simon', 'Page', 'Treasurer', 'Simon.Page@uvm.edu', 2023),
('Max', 'Bierdan', 'Technical Director', 'Maxwell.Bierden@uvm.edu', 2025),
('Annika', 'Safford', 'Public Relations Officer', 'Annika.Safford@uvm.edu', 2024),
('Anja', 'Samsom', 'Social Media Manager', 'Anja.Samsom@uvm.edu', 2024)