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
CREATE TABLE tblExperienceSurvey (
    pmkExperienceSurveyId int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
    fldName varchar(50) DEFAULT NULL,
    fldEmail varchar(50) DEFAULT NULL,
    fldOwner varchar(15) DEFAULT NULL,
    fldSyrian tinyint(1) DEFAULT 0,
    fldChinese tinyint(1) DEFAULT 0,
    fldWinterWhiteDwarf tinyint(1) DEFAULT 0,
    fldCampbellsDwarf tinyint(1) DEFAULT 0,
    fldRoborovski tinyint(1) DEFAULT 0,
    fldOther tinyint(1) DEFAULT 0
    )
INSERT INTO tblExperienceSurvey(fldName,fldEmail,fldOwner,fldSyrian,fldChinese,fldWinterWhiteDwarf,fldCampbellsDwarf,fldRoborovski,fldOther)
VALUES('Jay','aigershm@uvm.edu','Yes',1,1,1,1,1,0);