Saving the Bees

Create Table SQL

CREATE TABLE tblEcon(
    pmkBeeID INT AUTO_INCREMENT PRIMARY KEY,
    fldType VARCHAR(15),
    fldJob VARCHAR(50),
    fldWorth VARCHAR(20)
);

Insert Table Data SQL

INSERT INTO tblEcon(fldType, fldJob, fldWorth) VALUES
('Honey Bee', 'Pollinate virtually any crop, produce honey and beeswax', '$20 Billion'),
('Native Bees', 'Pollinate berries, alfalfa, and citrus fruits, supplement to commercial honey bee colonies', '$4 Billion'),
('Midge', 'Pollinate cacao plants', '$5.7 Billion');

Select data for display

SELECT fldType, fldJob, fldWorth FROM tblEcon 

Create Table SQL

CREATE TABLE tblForm(
    pmkBeeurveyID INT AUTO_INCREMENT PRIMARY KEY,
    fldFirst VARCHAR(30),
    fldLast VARCHAR(30),
    fldEmail VARCHAR(50),
    fldStatus VARCHAR (10),
    fldHoney TINYINT(1),
    fldBumble TINYINT(1),
    fldCarpenter TINYINT(1),
    fldMason TINYINT(1),
    fldSquash TINYINT(1),
    fldIssue VARCHAR(30),
    fldComments TEXT
);

Insert Table Data SQL

INSERT INTO tblForm(fldFirst, fldLast, fldEmail, fldStatus, fldHoney, fldBumble, fldCarpenter, fldMason, fldSquash, fldIssue, fldComments) VALUES
('Stephanie', 'Godes', 'sgodes@uvm.edu', 'Student', '1', '1', '0', '0', '0', 'extinction of bee species', 'hello');