Saving the Bees, One Garden at a Time

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