Jay Fisher

Write 3 update and delete statements

Updated names of the materials to more end-user friendly rather than codes. Deleted LOTAC and Scrim(no longer offer) and row 1 from Signs.

  • September 20, 2017 at 12:16 PM
  • Visible to public
UPDATE Materials SET name = "Standard Polymatte WR/TR" WHERE mat_id= 1;
UPDATE Materials SET name = "Heavy Fabric" WHERE mat_id= 2;
UPDATE Materials SET name = "Scrim" WHERE mat_id= 3;
UPDATE Materials SET name = "Backlit" WHERE mat_id= 4;
UPDATE Materials SET name = "Perforated Window Mesh" WHERE mat_id= 5;
UPDATE Materials SET name = "Cooler Wrap" WHERE mat_id= 6;

DELETE FROM Materials WHERE name="LOTAC";
DELETE FROM Materials WHERE name="Scrim";

DELETE FROM Signs WHERE id = 1;