Francisco Cruz

Write 3 update and delete statements

Three Update & Delete Statements

  • October 24, 2016 at 1:34 PM
  • Visible to public 
UPDATE Soccer_players 
SET name= 'Mario Goetze'
WHERE name= 'Mario G';

UPDATE SOCCER_players
SET name= 'Neymar'
Where name= 'Neymar da Silva';

UPDATE Soccer_players
SET team= 'Borussia Dortmund'
Where name= 'Mario Goetze';

DELETE From Soccer_Players
Where name= 'Cristiano Ronaldo';

Delete From Soccer_Players
Where name= 'Mats Hummels';

Delete From Soccer_Players
Where name= 'Luis Suarez';