Jay Fisher

Craft 3 insert statements to populate data

Insert statements to populate my 3 types of finishes and 7 types of materials into there table and place 1 example sign into Sign table.

  • September 20, 2017 at 11:44 AM
  • Visible to public
INSERT INTO Finishes VALUES(1, "Power Tabs", 1.44);
INSERT INTO Finishes VALUES(2, "Grommets", 1.82);
INSERT INTO Finishes VALUES(3, "Power Tabs", 0.48);

INSERT INTO Materials VALUES(1, "PMWR", 0.52);
INSERT INTO Materials VALUES(2, "WRFAB", 0.65);
INSERT INTO Materials VALUES(3, "QDSCRIM", 0.76);
INSERT INTO Materials VALUES(4, "BACKLIT", 0.76);
INSERT INTO Materials VALUES(5, "EPERF", 1.54);
INSERT INTO Materials VALUES(6, "WALLTAC", 1.10);
INSERT INTO Materials VALUES(7, "LOTAC", 0.81);

INSERT INTO Signs VALUES(1, 2.0, 3.0, 1, 3, 1, 6.00);