mysql> INSERT INTO school (name, country, capacity)
    -> VALUES ('Castelbruxo', 'Brazil', '380'),
    -> ('Durmstrang Institute','Norway','570'),
    -> ('Hogwarts School of Witchcraft and Wizardry ','United Kingdom','450'),
    -> ('Ilvermorny School of Witchcraft and Wizardry ','USA','300'),
    -> ('Koldovstoretz','Russia','125'),
    -> ('Mahoutokoro School of Magic','Japan','800'),
    -> ('Uagadou School of Magic', 'Uganda', '350');
Query OK, 7 rows affected (0.06 sec)
Records: 7  Duplicates: 0  Warnings: 0


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


mysql> UPDATE school SET capacity='700' WHERE country = 'Japan';
Query OK, 1 row affected (0.04 sec)
Rows matched: 1  Changed: 1  Warnings: 0


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


mysql> SELECT * FROM school;
+----+-----------------------------------------------+----------------+----------+
| id | name                                          | country        | capacity |
+----+-----------------------------------------------+----------------+----------+
|  2 | Castelbruxo                                   | 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 |
+----+-----------------------------------------------+----------------+----------+
5 rows in set (0.00 sec)