Jay Gershman

SQL

Create table

CREATE TABLE tblClasses(
    pmkRelClassesId INT AUTO_INCREMENT PRIMARY KEY,
    fldClass VARCHAR(100),
    fldSkillsLearned VARCHAR(150)
)
CREATE TABLE tblExperienceSurvey (
    pmkExperienceSurveyId int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    fldName varchar(50) DEFAULT NULL,
    fldEmail varchar(50) DEFAULT NULL,
    fldOwner varchar(15) DEFAULT NULL,
    fldSyrian tinyint(1) DEFAULT 0,
    fldChinese tinyint(1) DEFAULT 0,
    fldWinterWhiteDwarf tinyint(1) DEFAULT 0,
    fldCampbellsDwarf tinyint(1) DEFAULT 0,
    fldRoborovski tinyint(1) DEFAULT 0,
    fldOther tinyint(1) DEFAULT 0
    )
INSERT INTO tblExperienceSurvey(fldName,fldEmail,fldOwner,fldSyrian,fldChinese,fldWinterWhiteDwarf,fldCampbellsDwarf,fldRoborovski,fldOther)
VALUES('Jay','aigershm@uvm.edu','Yes',1,1,1,1,1,0);