SQL Foundations I Module 1

Write 3 update and delete statements

Only editable by group admins

  • Last updated August 24, 2016 at 1:07 PM
  • Evidence visible to public
Write 3 update and delete statements to manipulate the data in each table. Submit a URL for SQLFiddle or other location where your work can be publicly viewed.

All posted evidence

Link for update and delete statements.

kfowler About 8 years ago
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';
slewis52 About 8 years ago