SQL

Create Table

        CREATE TABLE tblFish(
            pmkFishId INT AUTO_INCREMENT PRIMARY KEY,
            fldType varchar(12),
            fldClimate varchar(10),
            fldWeight varchar(4),
            fldLength varchar(7)
        ) 
        

Insert Data

            INSERT INTO tblFish (fldType, fldClimate, fldWeight, fldLength) VALUES 
            ('Large Mouth', 'Mild', '1-5', '13-20'),
            ('Small Mouth', 'Mild', '1-4', '11-14'),
            ('Peacock', 'Tropical', '1-2', '11-14')
        

Select Records

            SELECT fldType, fldClimate, fldWeight, fldLength FROM tblFish