SHARE
TWEET

Untitled

a guest May 24th, 2019 54 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 1) UPDATE school SET country = 'Sweden' WHERE name='Durmstrang Institute';
  2.  
  3. 2) UPDATE school SET capacity = 700 WHERE name='Mahoutokoro School of Magic';
  4.  
  5. 3) DELETE FROM school WHERE name LIKE '%Magic%';
  6.  
  7. 4) SELECT name, country, capacity FROM school;
  8.  
  9. +----------------------------------------------+----------------+----------+
  10. | name                                         | country        | capacity |
  11. +----------------------------------------------+----------------+----------+
  12. | Castelobruxo                                 | Brasil         |      380 |
  13. | Durmstrang Institute                         | Sweden         |      570 |
  14. | Hogwarts School of Witchcraft and Wizardry   | United Kingdom |      450 |
  15. | Ilvermorny School of Witchcraft and Wizardry | USA            |      300 |
  16. | Koldovstoretz                                | Russia         |      125 |
  17. +----------------------------------------------+----------------+----------+
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top