MariaDB [(none)]> use toyu
Database changed
MariaDB [toyu]> SELECT * 
    -> FROM student;
+--------+-----------+----------+-------+-------+------+---------+
| stuId  | fname     | lname    | major | minor | ach  | advisor |
+--------+-----------+----------+-------+-------+------+---------+
| 100000 | Tony      | Hawk     | CSCI  | CINF  |   40 |    1011 |
| 100001 | Mary      | Hawk     | CSCI  | CINF  |   35 |    1011 |
| 100002 | David     | Hawk     | CSCI  | ITEC  |   66 |    1012 |
| 100003 | Catherine | Lim      | ITEC  | CINF  |   20 |    NULL |
| 100004 | Larry     | Johnson  | ITEC  | NULL  |   66 |    1017 |
| 100005 | Linda     | Johnson  | CINF  | ENGL  |   13 |    1015 |
| 100006 | Lillian   | Johnson  | CINF  | ITEC  |   18 |    1016 |
| 100007 | Ben       | Zico     | NULL  | NULL  |   16 |    NULL |
| 100008 | Bill      | Ching    | ARTS  | NULL  |   90 |    NULL |
| 100009 | Linda     | King     | ARTS  | CSCI  |  125 |    1018 |
| 100111 | Cathy     | Johanson | NULL  | NULL  |    0 |    1018 |
+--------+-----------+----------+-------+-------+------+---------+
11 rows in set (0.014 sec)

MariaDB [toyu]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| swim               |
| test               |
| toyu               |
+--------------------+
7 rows in set (0.006 sec)

MariaDB [toyu]> show tables
    -> ;
+----------------+
| Tables_in_toyu |
+----------------+
| class          |
| course         |
| department     |
| deptinfo       |
| enroll         |
| faculty        |
| grade          |
| school         |
| student        |
+----------------+
9 rows in set (0.002 sec)

MariaDB [toyu]> DROP SCHEMA IF EXISTS toyu;
Query OK, 9 rows affected (0.066 sec)

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| swim               |
| test               |
+--------------------+
6 rows in set (0.001 sec)

MariaDB [(none)]> source Createtoyu.sql
Query OK, 0 rows affected (0.002 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected, 1 warning (0.001 sec)

Query OK, 1 row affected (0.003 sec)

Database changed
Query OK, 0 rows affected, 1 warning (0.001 sec)

Query OK, 0 rows affected, 1 warning (0.001 sec)

Query OK, 0 rows affected, 1 warning (0.001 sec)

Query OK, 0 rows affected, 1 warning (0.002 sec)

Query OK, 0 rows affected, 1 warning (0.001 sec)

Query OK, 0 rows affected, 1 warning (0.001 sec)

Query OK, 0 rows affected, 1 warning (0.001 sec)

Query OK, 0 rows affected, 1 warning (0.001 sec)

Query OK, 0 rows affected, 1 warning (0.018 sec)

Query OK, 0 rows affected, 1 warning (0.013 sec)

Query OK, 0 rows affected, 1 warning (0.014 sec)

Query OK, 0 rows affected, 1 warning (0.014 sec)

Query OK, 0 rows affected, 1 warning (0.012 sec)

Query OK, 0 rows affected, 1 warning (0.014 sec)

Query OK, 0 rows affected, 1 warning (0.018 sec)

Query OK, 0 rows affected, 1 warning (0.018 sec)

Query OK, 0 rows affected (0.006 sec)

Query OK, 0 rows affected (0.004 sec)

Query OK, 0 rows affected (0.005 sec)

Query OK, 0 rows affected (0.004 sec)

Query OK, 0 rows affected (0.005 sec)

Query OK, 15 rows affected (0.004 sec)
Records: 15  Duplicates: 0  Warnings: 0

Query OK, 4 rows affected (0.006 sec)
Records: 4  Duplicates: 0  Warnings: 0

Query OK, 7 rows affected (0.003 sec)
Records: 7  Duplicates: 0  Warnings: 0

Query OK, 11 rows affected (0.003 sec)
Records: 11  Duplicates: 0  Warnings: 0

Query OK, 11 rows affected (0.002 sec)
Records: 11  Duplicates: 0  Warnings: 0

Query OK, 14 rows affected (0.006 sec)
Records: 14  Duplicates: 0  Warnings: 0

Query OK, 11 rows affected (0.003 sec)
Records: 11  Duplicates: 0  Warnings: 0

Query OK, 22 rows affected (0.006 sec)
Records: 22  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.001 sec)

Query OK, 0 rows affected (0.000 sec)

Query OK, 0 rows affected (0.000 sec)

MariaDB [toyu]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| swim               |
| test               |
| toyu               |
+--------------------+
7 rows in set (0.002 sec)

MariaDB [toyu]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| swim               |
| test               |
| toyu               |
+--------------------+
7 rows in set (0.001 sec)

MariaDB [toyu]> notee