Summer Lewis

Write 3 update and delete statements

http://sqlfiddle.com/#!9/d7319

  • October 5, 2016 at 10:02 PM
  • Last updated about 8 years ago
  • Visible to public
Here is the link to my complete ddl escapades:
http://sqlfiddle.com/#!9/d7319

In case the link doesn't work, here's a screenshot of my update and delete statements:
https://gyazo.com/8cc40eb41d987e916203596ab36c14f7

Here's the specific ddl I used for my UPDATE/DELETE requirement (just a segment of full ddl):

UPDATE ProductsSET ItemLocation='04-25-00-00', NumberInStock='96'
WHERE ItemNumber='QWER1234';

UPDATE OrdersSET ItemsOrdered='QWER1234, TYUI4321', TotalCost='32.42'
WHERE OrderNumber='123456789';

UPDATE CustomersSET PhoneNumber='789-456-1230'
WHERE CustomerID='CuSto1234';

DELETE FROM Customers
WHERE CustomerID='CuSto1234' AND LastName='Stove';

DELETE FROM Products
WHERE ItemNumber='TYUI4321' AND ItemLocation='02-34-10-08';

DELETE FROM Orders
WHERE OrderNumber='798465123' AND TimePrinted='2016-05-04 11:01:22';