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

MariaDB [(none)]> source createtoyu.sql
Query OK, 0 rows affected (0.000 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.005 sec)

Query OK, 1 row affected (0.003 sec)

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

Query OK, 0 rows affected, 1 warning (0.000 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.000 sec)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Query OK, 22 rows affected (0.012 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]> 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.000 sec)

MariaDB [toyu]> use swim;
Database changed
MariaDB [swim]> SELECT *
    -> FROm student;
ERROR 1146 (42S02): Table 'swim.student' doesn't exist
MariaDB [swim]>
MariaDB [swim]> SELECT student.*
    -> FROM student;
ERROR 1146 (42S02): Table 'swim.student' doesn't exist
MariaDB [swim]> SELECT *
    -> FROM toyu.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.000 sec)

MariaDB [swim]> DROP SCHEMA IF EXISTS toyu;
Query OK, 8 rows affected (0.150 sec)

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

MariaDB [swim]> source createtoyu.sql
Query OK, 0 rows affected (0.000 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.001 sec)

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

Query OK, 0 rows affected, 1 warning (0.000 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.031 sec)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Query OK, 0 rows affected (0.000 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.003 sec)

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