Adopting Your First Hamster

Basic Care

SQL

Create table

CREATE TABLE tblSpeciesOverview(
    pmkSpeciesOverviewId INT AUTO_INCREMENT PRIMARY KEY,
    fldSpecies VARCHAR(25),
    fldSize VARCHAR(15),
    fldSolitary VARCHAR(20),
    fldHandleability VARCHAR(10)
)

Insert Data

INSERT INTO tblSpeciesOverview (fldSpecies, fldSize, fldSolitary, fldHandleability) VALUES
    ('Syrians', '5 - 7 in', 'solitary', 'very easy'),
    ('Chinese', '3.2 - 5 in', 'solitary', 'easy'),
    ('Winter White Dwarfs', '2.7 - 3.5 in', 'can live in groups', 'medium'),
    ('Campbell\'s Dwarfs', '2 - 4 in', 'can live in groups', 'medium'),
    ('Roborovskis', '1.7 - 2 in', 'can live in groups', 'difficult')

Select records

SELECT fldSpecies, fldSize, fldSolitary, fldHandleability FROM tblSpeciesOverview