//“Durmstrang Institute” est en réalité en Suède (Sweden), modifie son pays.


mysql> UPDATE school SET country='Sweden' WHERE id=3;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> SELECT * FROM school;
+----+----------------------------------------------+----------------+----------+
| id | name                                         | country        | capacity |
+----+----------------------------------------------+----------------+----------+
|  1 | Beauxbatons Academy of Magic                 | France         | 550      |
|  2 | Castelobruxo                                 | Brazil         | 380      |
|  3 | Durmstrang Institute                         | Sweden         | 570      |
|  4 | Hogwarts School of Witchcraft and Wizardry   | United Kingdom | 450      |
|  5 | Ilvermorny School of Witchcraft and Wizardry | USA            | 300      |
|  6 | Koldovstoretz                                | Russia         | 125      |
|  7 | Mahoutokoro School of Magic                  | Japan          | 800      |
|  8 | Uagadou School of Magic                      | Uganda         | 350      |
+----+----------------------------------------------+----------------+----------+


//“Mahoutokoro School of Magic” passe à une capacité de 700


mysql> UPDATE school SET capacity=700 WHERE id=7;
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> SELECT * FROM school;
+----+----------------------------------------------+----------------+----------+
| id | name                                         | country        | capacity |
+----+----------------------------------------------+----------------+----------+
|  1 | Beauxbatons Academy of Magic                 | France         | 550      |
|  2 | Castelobruxo                                 | Brazil         | 380      |
|  3 | Durmstrang Institute                         | Sweden         | 570      |
|  4 | Hogwarts School of Witchcraft and Wizardry   | United Kingdom | 450      |
|  5 | Ilvermorny School of Witchcraft and Wizardry | USA            | 300      |
|  6 | Koldovstoretz                                | Russia         | 125      |
|  7 | Mahoutokoro School of Magic                  | Japan          | 700      |
|  8 | Uagadou School of Magic                      | Uganda         | 350      |
+----+----------------------------------------------+----------------+----------+


/*Supprime en une seule requête toutes les écoles comportant “Magic” dans leur nom (il y en a 3).
Tu peux t’aider du mot clé LIKE.*/


mysql> DELETE FROM school WHERE name LIKE '%Magic';
Query OK, 3 rows affected (0.00 sec)

mysql> SELECT * FROM school;
+----+----------------------------------------------+----------------+----------+
| id | name                                         | country        | capacity |
+----+----------------------------------------------+----------------+----------+
|  2 | Castelobruxo                                 | Brazil         | 380      |
|  3 | Durmstrang Institute                         | Sweden         | 570      |
|  4 | Hogwarts School of Witchcraft and Wizardry   | United Kingdom | 450      |
|  5 | Ilvermorny School of Witchcraft and Wizardry | USA            | 300      |
|  6 | Koldovstoretz                                | Russia         | 125      |
+----+----------------------------------------------+----------------+----------+

//Ensuite, affiche via une requête SELECT toutes les données de la table school