SQL

Create table

        CREATE TABLE tblCityInformation(
            pmkCityInformationId INT AUTO_INCREMENT PRIMARY KEY,
            fldCity VARCHAR(20),
            fldCurrency VARCHAR(30),
            fldPopulation VARCHAR(20),
            fldLanguageSpoken VARCHAR(40)
        )
    

Insert Data

    INSERT INTO tblCityInformation
    (fldCity, fldCurrency, fldPopulation, fldLanguageSpoken) VALUES
    ('Bandung','Indonesian Rupiah','2.6 million','Indonesian and English'),
    ('Jakarta','Indonesian Rupiah','10.6 million','Indonesian and English'),
    ('Ubud','Indonesian Rupiah',74800,'Indonesian and English'),
    ('Montreal','Canadian Dollar','1.78 million','French and English'),
    ('Quebec City','Canadian Dollar',705103,'French and English')
    
    

Select Records

    SELECT fldCompany, fldOrigin, fldWages, fldStoreQuantity FROM tblFastFashionCompanies
    

Create Table SQL

    CREATE TABLE tblTravelSurvey(
        pmkTravelSurveyId int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
        fldFirstName varchar(50) DEFAULT NULL,
        fldLastName varchar(50) DEFAULT NULL,
        fldEmail varchar(50) DEFAULT NULL,
        fldAmerica tinyint(1) DEFAULT 0,
        fldEurope tinyint(1) DEFAULT 0,
        fldAfrica tinyint(1) DEFAULT 0,
        fldAsia tinyint(1) DEFAULT 0,
        fldAustrailia tinyint(1) DEFAULT 0,
        fldVacation varchar(40) DEFAULT NULL,
        fldQuestion varchar(300) DEFAULT NULL
    )
    

        INSERT INTO tblTravelSurvey
        (pmkTravelSurveyId, fldFirstName,fldLastName, fldEmail,fldAmerica,fldEurope,
        fldAfrica, fldAsia, fldAustrailia, fldVacation, fldQuestion)
        Values
        (1,'Abigail','Simanjuntak','asimanju@uvm.edu',0,1,0,0,0,'National Park Vacation','No');