MariaDB [toyu]> SELECT stuId
    -> FROM enroll;
+--------+
| stuId  |
+--------+
| 100000 |
| 100000 |
| 100000 |
| 100000 |
| 100000 |
| 100000 |
| 100001 |
| 100001 |
| 100002 |
| 100002 |
| 100002 |
| 100004 |
| 100004 |
| 100005 |
| 100005 |
| 100005 |
| 100005 |
| 100006 |
| 100006 |
| 100007 |
| 100007 |
| 100008 |
+--------+
22 rows in set (0.002 sec)

MariaDB [toyu]> SELECT DISTINCT stuId
    -> FROM enroll;
+--------+
| stuId  |
+--------+
| 100000 |
| 100001 |
| 100002 |
| 100004 |
| 100005 |
| 100006 |
| 100007 |
| 100008 |
+--------+
8 rows in set (0.003 sec)

MariaDB [toyu]> SELECT DISTINCT s.stuId, s.fname
    -> FROM student AS s
    -> WHERE s.lname = 'Hawk';
+--------+-------+
| stuId  | fname |
+--------+-------+
| 100000 | Tony  |
| 100001 | Mary  |
| 100002 | David |
+--------+-------+
3 rows in set (0.001 sec)

MariaDB [toyu]> SELECT 1;
+---+
| 1 |
+---+
| 1 |
+---+
1 row in set (0.001 sec)

MariaDB [toyu]> SELECT 1+2;
+-----+
| 1+2 |
+-----+
|   3 |
+-----+
1 row in set (0.002 sec)

MariaDB [toyu]> 
MariaDB [toyu]> DROP SCHEMA IF EXISTS tinker;
Query OK, 0 rows affected, 1 warning (0.001 sec)

MariaDB [toyu]> CREATE SCHEMA tinker;
Query OK, 1 row affected (0.003 sec)

MariaDB [toyu]> USE tinker;
Database changed
MariaDB [tinker]> show databases;
+--------------------+
| Database           |
+--------------------+
| ctetinker          |
| dbtool             |
| ds                 |
| information_schema |
| mysql              |
| performance_schema |
| phpmyadmin         |
| swim               |
| tinker             |
| toyu               |
+--------------------+
10 rows in set (0.003 sec)

MariaDB [tinker]> show tables;
Empty set (0.002 sec)

MariaDB [tinker]> CREATE TABLE s2
    -> SELECT * FROM toyu.student;
Query OK, 11 rows affected (0.049 sec)
Records: 11  Duplicates: 0  Warnings: 0

MariaDB [tinker]> SELECT *
    -> FROM s2;
+--------+-----------+----------+-------+-------+------+---------+
| 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.001 sec)

MariaDB [tinker]> 
MariaDB [tinker]> CREATE TEMPORARY TABLE s3
    -> SELECT * FROM toyu.student;
Query OK, 11 rows affected (0.006 sec)
Records: 11  Duplicates: 0  Warnings: 0

MariaDB [tinker]> SELECT *
    -> FROM s3;
+--------+-----------+----------+-------+-------+------+---------+
| 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 [tinker]> show tables;
+------------------+
| Tables_in_tinker |
+------------------+
| s2               |
+------------------+
1 row in set (0.001 sec)

MariaDB [tinker]> CREATE TABLE s4 LIKE toyu.student;
Query OK, 0 rows affected (0.056 sec)

MariaDB [tinker]> SELECT *
    -> FROM s4;
Empty set (0.000 sec)

MariaDB [tinker]> INSERT INTO s4
    -> SELECT * FROM toyu.student;
Query OK, 11 rows affected (0.006 sec)
Records: 11  Duplicates: 0  Warnings: 0

MariaDB [tinker]> 
MariaDB [tinker]> SELECT *
    -> FROM s4;
+--------+-----------+----------+-------+-------+------+---------+
| 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.001 sec)

MariaDB [tinker]> DESC student;
ERROR 1146 (42S02): Table 'tinker.student' doesn't exist
MariaDB [tinker]> DESC s2;
+---------+-----------------+------+-----+---------+-------+
| Field   | Type            | Null | Key | Default | Extra |
+---------+-----------------+------+-----+---------+-------+
| stuId   | int(11)         | NO   |     | NULL    |       |
| fname   | varchar(30)     | NO   |     | NULL    |       |
| lname   | varchar(30)     | NO   |     | NULL    |       |
| major   | char(4)         | YES  |     | NULL    |       |
| minor   | char(4)         | YES  |     | NULL    |       |
| ach     | int(3) unsigned | YES  |     | 0       |       |
| advisor | int(11)         | YES  |     | NULL    |       |
+---------+-----------------+------+-----+---------+-------+
7 rows in set (0.021 sec)

MariaDB [tinker]> DESC toyu.student;
+---------+-----------------+------+-----+---------+-------+
| Field   | Type            | Null | Key | Default | Extra |
+---------+-----------------+------+-----+---------+-------+
| stuId   | int(11)         | NO   | PRI | NULL    |       |
| fname   | varchar(30)     | NO   |     | NULL    |       |
| lname   | varchar(30)     | NO   |     | NULL    |       |
| major   | char(4)         | YES  | MUL | NULL    |       |
| minor   | char(4)         | YES  | MUL | NULL    |       |
| ach     | int(3) unsigned | YES  |     | 0       |       |
| advisor | int(11)         | YES  | MUL | NULL    |       |
+---------+-----------------+------+-----+---------+-------+
7 rows in set (0.030 sec)

MariaDB [tinker]> DESC s2;
+---------+-----------------+------+-----+---------+-------+
| Field   | Type            | Null | Key | Default | Extra |
+---------+-----------------+------+-----+---------+-------+
| stuId   | int(11)         | NO   |     | NULL    |       |
| fname   | varchar(30)     | NO   |     | NULL    |       |
| lname   | varchar(30)     | NO   |     | NULL    |       |
| major   | char(4)         | YES  |     | NULL    |       |
| minor   | char(4)         | YES  |     | NULL    |       |
| ach     | int(3) unsigned | YES  |     | 0       |       |
| advisor | int(11)         | YES  |     | NULL    |       |
+---------+-----------------+------+-----+---------+-------+
7 rows in set (0.021 sec)

MariaDB [tinker]> DESC s4;
+---------+-----------------+------+-----+---------+-------+
| Field   | Type            | Null | Key | Default | Extra |
+---------+-----------------+------+-----+---------+-------+
| stuId   | int(11)         | NO   | PRI | NULL    |       |
| fname   | varchar(30)     | NO   |     | NULL    |       |
| lname   | varchar(30)     | NO   |     | NULL    |       |
| major   | char(4)         | YES  | MUL | NULL    |       |
| minor   | char(4)         | YES  | MUL | NULL    |       |
| ach     | int(3) unsigned | YES  |     | 0       |       |
| advisor | int(11)         | YES  | MUL | NULL    |       |
+---------+-----------------+------+-----+---------+-------+
7 rows in set (0.014 sec)

MariaDB [tinker]> DROP TABLE s2;
Query OK, 0 rows affected (0.018 sec)

MariaDB [tinker]> DROP TABLE s3;
Query OK, 0 rows affected (0.003 sec)

MariaDB [tinker]> DROP TABLE s4;
Query OK, 0 rows affected (0.029 sec)

MariaDB [tinker]> 
MariaDB [tinker]> SHOW TABLES;
Empty set (0.001 sec)

MariaDB [tinker]> 
MariaDB [tinker]> DROP SCHEMA IF EXISTS tinker;
Query OK, 0 rows affected (0.009 sec)

MariaDB [(none)]> UPDATE Student
    -> SET major = 'ITEC'
    -> WHERE StuId = 100000;
ERROR 1046 (3D000): No database selected
MariaDB [(none)]> use toyu;
Database changed
MariaDB [toyu]> UPDATE Student
    -> SET major = 'ITEC'
    -> WHERE StuId = 100000;
Query OK, 1 row affected (0.007 sec)
Rows matched: 1  Changed: 1  Warnings: 0

MariaDB [toyu]> UPDATE Student
    -> SET major = 'CSCI';
Query OK, 9 rows affected (0.007 sec)
Rows matched: 11  Changed: 9  Warnings: 0

MariaDB [toyu]> 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, 9 rows affected (0.183 sec)

Query OK, 1 row affected (0.002 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.000 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.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.022 sec)

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

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

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

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

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

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

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

Query OK, 0 rows affected (0.014 sec)

Query OK, 0 rows affected (0.012 sec)

Query OK, 0 rows affected (0.015 sec)

Query OK, 0 rows affected (0.013 sec)

Query OK, 0 rows affected (0.012 sec)

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

Query OK, 4 rows affected (0.005 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.006 sec)
Records: 11  Duplicates: 0  Warnings: 0

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

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

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

Query OK, 22 rows affected (0.020 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]> notee