SQL

Create table

        CREATE TABLE tblFastFashionCompanies(
            pmkFastFashionCompaniesId INT AUTO_INCREMENT PRIMARY KEY,
            fldCompany VARCHAR(20),
            fldOrigin VARCHAR(30),
            fldWages VARCHAR(20),
            fldStoreQuantity VARCHAR(20)
        )
    

Insert Data

    INSERT INTO tblFastFashionCompanies
    (fldCompany, fldOrigin, fldWages, fldStoreQuantity) VALUES
    ('Zara','Spain','No',540),
    ('Forever 21','America','No',2200),
    ('H&M','Sweden','No',3500)
    

Select Records

    SELECT fldCompany, fldOrigin, fldWages, fldStoreQuantity FROM tblFastFashionCompanies
    

Create Table SQL

    CREATE TABLE tblFastFashionSurvey(
        pmkFastFashionSurvey int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
        fldFirstName varchar(50) DEFAULT NULL,
        fldLastName varchar(50) DEFAULT NULL,
        fldEmail varchar(50) DEFAULT NULL,
        fldThrifting tinyint(1) DEFAULT 0,
        fldSustainable tinyint(1) DEFAULT 0,
        fldUpcycling tinyint(1) DEFAULT 0,
        fldStore varchar(11) DEFAULT NULL
    )
    

        INSERT INTO tblFastFashionSurvey
        (pmkFastFashionSurvey, fldFirstName,fldLastName, fldEmail,fldThrifting,fldSustainable,
        fldUpcycling, fldStore)
        Values
        (1,'Abigail','Simanjuntak','asimanju@uvm.edu',0,1,0,'Zara');