mysql> INSERT INTO school
    -> (s_name, s_country, s_capacity)
    -> VALUES ('Beauxbatons Academy of Magic', 'France', 550),
    -> ('Castelobruxo ', '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, 8 rows affected (0.01 sec)
Records: 8  Duplicates: 0  Warnings: 0

mysql> SELECT * FROM school;
+------+----------------------------------------------+------------+----------------+
| s_id | s_name                                       | s_capacity | s_country      |
+------+----------------------------------------------+------------+----------------+
|    1 | Beauxbatons Academy of Magic                 |        550 | France         |
|    2 | Castelobruxo                                 |        380 | Brazil         |
|    3 | Durmstrang Institute                         |        570 | Norway         |
|    4 | Hogwarts School of Witchcraft and Wizardry   |        450 | United Kingdom |
|    5 | Ilvermorny School of Witchcraft and Wizardry |        300 | USA            |
|    6 | Koldovstoretz                                |        125 | Russia         |
|    7 | Mahoutokoro School of Magic                  |        800 | Japan          |
|    8 | Uagadou School of Magic                      |        350 | Uganda         |
+------+----------------------------------------------+------------+----------------+
8 rows in set (0.00 sec)

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

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

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

mysql> SELECT * FROM school;
+------+----------------------------------------------+------------+----------------+
| s_id | s_name                                       | s_capacity | s_country      |
+------+----------------------------------------------+------------+----------------+
|    2 | Castelobruxo                                 |        380 | Brazil         |
|    3 | Durmstrang Institute                         |        570 | Sweden         |
|    4 | Hogwarts School of Witchcraft and Wizardry   |        450 | United Kingdom |
|    5 | Ilvermorny School of Witchcraft and Wizardry |        300 | USA            |
|    6 | Koldovstoretz                                |        125 | Russia         |
+------+----------------------------------------------+------------+----------------+
5 rows in set (0.00 sec)