mateagnes

Last login: Tue Mar  2 08:55:22 on ttys000
mateagnes@Agness-Air ~ % pwd
/Users/mateagnes
mateagnes@Agness-Air ~ % cd.. 
zsh: command not found: cd..
mateagnes@Agness-Air ~ % cd ..
mateagnes@Agness-Air /Users % 
mateagnes@Agness-Air /Users % pwd
/Users
mateagnes@Agness-Air /Users % ls

mateagnes

mateagnes@Agness-MacBook-Air Downloads % cd planets
mateagnes@Agness-MacBook-Air planets % mkdir real
mateagnes@Agness-MacBook-Air planets % mkdir fictional
mateagnes@Agness-MacBook-Air planets % mkdir inhabited
mateagnes@Agness-MacBook-Air planets % cd real
mateagnes@Agness-MacBook-Air real % mkdir terrestrial
mateagnes@Agness-MacBook-Air real % mkdir gas-giants
mateagnes@Agness-MacBook-Air real % mkdir dwarf-planets
mateagnes@Agness-MacBook-Air real % cd ..
mateagnes@Agness-MacBook-Air planets % ls

mateagnes

//checking if the import has been succesful

mysql> SELECT * FROM wizard;
+----+-----------+------------+------------+-------------+-------------------------------------------------------------+-----------+
| id | firstname | lastname   | birthday   | birth_place | biography                                                   | is_muggle |
+----+-----------+------------+------------+-------------+-------------------------------------------------------------+-----------+
|  1 | harry     | potter     | 1980-07-31 | london      |                                                             |         0 |
|  2 | hermione  | granger    | 1979-09-19 |             | Friend of Harry Potter                                      |         0 |
|  3 | lily      | potter     | 1960-01-30 |             | mother of Harry Potter                                      |         0 |
|  4 | ron       | weasley    | 1980-03-01 |             | Best friend of Harry                                        |         0 |

mateagnes

// inserting data to the school table

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