mysql> INSERT INTO school (name, country, capacity)
    -> VALUES ('Beauxbatons Academy of Magic', 'France', 550),
    -> ('Castelobruxo', 'Brazil', 380),
    -> ('Durmstrang Institute', 'Norway', 570);
Query OK, 3 rows affected (0,01 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> INSERT INTO school (name, country, capacity)
    -> VALUES ('Hogwarts School of Witchcraft and Wizardry', 'United Kingdom', 450);
Query OK, 1 row affected (0,00 sec)

mysql> INSERT INTO school (name, country, capacity) VALUES ('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, 4 rows affected (0,00 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> DESCRIBE school
    -> ;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| id       | int(11)      | NO   | PRI | NULL    | auto_increment |
| name     | varchar(100) | NO   |     | NULL    |                |
| country  | varchar(255) | NO   |     | NULL    |                |
| capacity | int(11)      | YES  |     | NULL    |                |
+----------+--------------+------+-----+---------+----------------+
4 rows in set (0,00 sec)

mysql> SELECT * school;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'school' at line 1
mysql> SELECT * FROM school;
+----+----------------------------------------------+----------------+----------+
| id | name                                         | country        | capacity |
+----+----------------------------------------------+----------------+----------+
|  1 | Hogwarts School of Witchcraft and Wizardry   | United Kingdom |      400 |
|  2 | Beauxbatons Academy of Magic                 | France         |      550 |
|  3 | Castelobruxo                                 | Brazil         |      380 |
|  4 | Durmstrang Institute                         | Norway         |      570 |
|  5 | Hogwarts School of Witchcraft and Wizardry   | United Kingdom |      450 |
|  6 | Ilvermorny School of Witchcraft and Wizardry | USA            |      300 |
|  7 | Koldovstoretz                                | Russia         |      125 |
|  8 | Mahoutokoro School of Magic                  | Japan          |      800 |
|  9 | Uagadou School of Magic                      | Uganda         |      350 |
+----+----------------------------------------------+----------------+----------+
9 rows in set (0,00 sec)

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

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

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

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

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

mysql> SELECT * FROM school;
+----+----------------------------------------------+----------------+----------+
| id | name                                         | country        | capacity |
+----+----------------------------------------------+----------------+----------+
|  1 | Hogwarts School of Witchcraft and Wizardry   | United Kingdom |      400 |
|  3 | Castelobruxo                                 | Brazil         |      380 |
|  4 | Durmstrang Institute                         | Sweden         |      570 |
|  5 | Hogwarts School of Witchcraft and Wizardry   | United Kingdom |      450 |
|  6 | Ilvermorny School of Witchcraft and Wizardry | USA            |      300 |
|  7 | Koldovstoretz                                | Russia         |      125 |
+----+----------------------------------------------+----------------+----------+
6 rows in set (0,00 sec)

mysql>