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);