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