Homework Planner

SQL statements

Create Table SQL

        CREATE TABLE tblPollution(
            pmkPollutionId INT AUTO_INCREMENT PRIMARY KEY,
            fldCountry VARCHAR(20),
            fldAirPollution FLOAT,
            fldAirQuality FLOAT
        )
        

Create table for forms display

CREATE TABLE tblBikerInfo (
        pmktblBikerInfoId INT AUTO_INCREMENT PRIMARY KEY,
        fldFullName VARCHAR(50),
        fldAge VARCHAR(20),
        fldEmail VARCHAR(50),
        fldKnowBike VARCHAR(10),
        fldCommuting boolean,
        fldRoad boolean,
        fldMountain boolean,
        fldUnsure boolean,
        fldNone boolean,
        fldColor VARCHAR(10),
        fldLetKnow text
);
        

Populate table with data

        INSERT INTO tblPollution(fldCountry, fldAirPollution, fldAirQuality) VALUES

        ('United States', '33.09', '66.91'),

        ('Germany', '23.58', '76.42'),

        ('Netherlands', '24.54', '75.46'),

        ('Spain', '32.77', '67.23');
        

        INSERT INTO tblBikerInfo(fldFullName, fldAge, fldEmail, fldKnowBike, fldCommuting, fldRoad, fldMountain, fldUnsure, fldNone, fldColor, fldLetKnow) VALUES

        ('John Doe', '25', 'johndoe@gmail.com', '1', '1','1','1', '0','0', 'Red', 'Nope');
        

Select data for display

        SELECT fldCountry, fldAirPollution, fldAirQuality FROM tblPollution