Create Table SQL
CREATE TABLE tblMaterials( pmkMaterialsId INT AUTO_INCREMENT PRIMARY KEY, fldMaterial VARCHAR(40), fldProcess VARCHAR(200), fldProblems VARCHAR(200) ) INSERT INTO tblMaterials (fldMaterial, fldProcess, fldProblems) VALUES ('Paper', 'Paper is broken down and re-constituted to form new paper', 'Toxic ink wastes, differing grades, limited amount of reuse'), ('Metal', 'Most metals can be melted and re-cast easily into new forms', 'A lot of steel and aluminum cans are thrown away'), ('Glass', 'Glass can be melted and re-formed many times', 'Two-thirds of glass bottles are thrown away'), ('Plastic', 'Plastic is often re-purposed to make different products', 'Different kinds of plastic must be recycled differently')