Matt Purnell

Write 3 update and delete statements

Update and Delete statements for Module I Task IV

November 26, 2017 at 2:42 PM
Visible to public

UPDATE University
SET University_Name = "Parkland Community College"
WHERE University_ID = 1492059;
UPDATE Course
SET Section = 1
WHERE Section = 3;
UPDATE Student
SET ID = 4726197
WHERE Username = "mpurnell1";

DELETE FROM Student WHERE University_ID = 7452956;
DELETE FROM Course WHERE University_ID = 7452956;
DELETE FROM University WHERE University_ID = 7452956;