Mangai Neelavannan

Write 3 update and delete statements

Update and delete statements

  • May 20, 2018 at 6:14 PM
  • Visible to public 
UPDATE DISCIPLINE
SET NUM_CREDITS = 120
WHERE CODE = ‘S0060’;
UPDATE STUDENT
SET STUDENT_LNAME = ‘Ferguson’
WHERE STUDENT_NUMBER = ‘S4’;
UPDATE STUDENT
SET STUDENT_NUMBER = ‘S14’
WHERE STUDENT_FNAME=’Arnold’;

DELETE FROM STUDENT
WHERE STUDENT_LNAME=’Perez’;
DELETE FROM DISCIPLINE
WHERE CODE = ‘S0120’;
DELETE FROM STUDENT
WHERE STUDENT_NUMBER = ‘S9’;