Making the World a Better Place

Create Compost Table

CREATE TABLE tblCompostMaterials (
    pmkCompostMaterialsId int NOT NULL
    AUTO_INCREMENT PRIMARY KEY,
    fldFoodScraps varchar(30) DEFAULT NULL,
    fldNaturalMaterials varchar(30) DEFAULT NULL,
    fldPaper varchar(250) DEFAULT NULL
)
        

Insert records into the table compostMaterials

        INSERT INTO tblCompostMaterials
        (pmkCompostMaterialsId, fldFoodScraps,
        fldNaturalMaterials, fldPaper)
        VALUES
(1,'fruit peels/rinds','grass clippings','newspaper'),
(2, 'coffee grounds', 'leaves', 'cardboard'),
(3, 'rotten vegetables', 'dead plants', 'napkins');   
        

Selecting Compost records

            SELECT pmkCompostMaterialsId,fldFoodScraps,fldNaturalMaterials, fldPaper FROM tblCompostMaterials