SQL statements
Create Table SQL
CREATE TABLE tblMaterials (
pmkMaterialsId INT AUTO_INCREMENT PRIMARY KEY,
fldMaterialsName varchar(20),
fldMaterialsCo varchar(50),
fldMaterialsHelp varchar(250)
);
Populate the table with data
INSERT INTO tblMaterials (fldMaterialsName,
fldMaterialsCo, fldMaterialsHelp) VALUES
('Yarn', 'Nike', 'Prevents billion plastic
bottles from reaching landfills' ),
('Sustainable cotton', 'Nike', 'Through the Better Cotton Initiative, organic cotton is
grown without fossil fuel procured pesticides or synthetic fertilizers.'),
('Yarn', 'Adidas', 'Diverts ocean pollutants from harming marine life and
fights the plastic waterbottle epidemic'),
('gillnet', 'Adidas', 'Decreases the killing of wildlife by
decreasing the amount of fishnets and gillnets left in the ocean.');
Select data for display
SELECT fldMaterialsName, fldMaterialsCo, fldMaterialsHelp FROM tblMaterials