INSERT INTO school (name, capacity, coutry) VALUES ("Beauxbatons Academy
of Magic", 550, "France");
INSERT INTO school (name, capacity, country) VALUES ("Castelobruxo", 380,
 "Brazil");
 INSERT INTO school (name, capacity, country) VALUES ("Durmstrang Institute", 570, "Norway");
 INSERT INTO school (name, capacity, country) VALUES ("Hogwarts School of Witchcraft and Wizardry", 450, "United Kingdom");
 INSERT INTO school (name, capacity, country) VALUES ("Ilvermorny School of Witchcraft and Wizardry", 300, "USA");
INSERT INTO school (name, capacity, country) VALUES ("oldovstoretz", 125,"Russia");
INSERT INTO school (name, capacity, country) VALUES ("Mahoutokoro School
of Magic", 800, "Japan");
INSERT INTO school (name, capacity, country) VALUES ("Uagadou School of Magic", 350, "Uganda");
+----+----------------------------------------------+----------------+----------+
|  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 |
+----+----------------------------------------------+----------------+----------+

*******************************************************************************************

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

UPDATE school SET country="Sweden" WHERE id=3;

****************************************************************************

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

UPDATE school SET capacity=700 WHERE id=7;

****************************************************************************

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.01 sec)

Résultats final:

+----+----------------------------------------------+----------------+----------+
| 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 |
+----+----------------------------------------------+----------------+----------+