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