Wisconsin Flora and Fauna (General Appreciation)

Opinions and Photos

SQL

Create table

        CREATE TABLE tblBackyardAnimals (
            pmkBackyardAnimalsId INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
            fldColor varchar(40),
            fldSuspectedSpecies varchar(20),
            fldMyOpinion varchar(100)
        )
        

Insert Data

        INSERT INTO tblBackyardAnimals (fldColor, fldSuspectedSpecies, fldMyOpinion) VALUES 
        ('Greyish', 'Baby Bunny', 'Very cute, enjoy almost every sighting'),
        ('Also grey with a white face', 'Opposum family', 'Piqued my interest, but defintely to be appreciated from afar (little freaky)'),
        ('A beautiful shade of red', 'Robin!!', 'It is the Wisconsin State Bird, so I love it dearly and I welcome the Robin with open arms')
        

Select records

        SELECT fldColor, fldSuspectedSpecies, fldMyOpinion FROM tblBackyardAnimals