MariaDB [toyu]> CREATE TEMPORARY TABLE t3 -> FROM SELECT * FROM student; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM SELECT * FROM student' at line 2 MariaDB [toyu]> CREATE TEMPORARY TABLE t3 -> AS SELECT * FROM student; Query OK, 11 rows affected (0.006 sec) Records: 11 Duplicates: 0 Warnings: 0 MariaDB [toyu]> desc t3; +---------+-------------+------+-----+---------+-------+ | 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) | YES | | 0 | | | advisor | int(11) | YES | | NULL | | +---------+-------------+------+-----+---------+-------+ 7 rows in set (0.009 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]> show databasesl -> ; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'databasesl' at line 1 MariaDB [toyu]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | phpmyadmin | | test | | toyu | +--------------------+ 6 rows in set (0.003 sec) MariaDB [toyu]> source createSwimDB.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.007 sec) Database changed 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.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.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.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.000 sec) Query OK, 0 rows affected, 1 warning (0.035 sec) Query OK, 0 rows affected, 1 warning (0.001 sec) Query OK, 0 rows affected, 1 warning (0.042 sec) Query OK, 0 rows affected, 1 warning (0.001 sec) Query OK, 0 rows affected, 1 warning (0.033 sec) Query OK, 0 rows affected, 1 warning (0.001 sec) Query OK, 0 rows affected, 1 warning (0.033 sec) Query OK, 0 rows affected, 1 warning (0.001 sec) Query OK, 0 rows affected, 1 warning (0.036 sec) Query OK, 0 rows affected, 1 warning (0.001 sec) Query OK, 0 rows affected, 1 warning (0.035 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.036 sec) Query OK, 0 rows affected, 1 warning (0.001 sec) Query OK, 0 rows affected, 1 warning (0.034 sec) Query OK, 0 rows affected, 1 warning (0.001 sec) Query OK, 0 rows affected, 1 warning (0.040 sec) Query OK, 0 rows affected, 1 warning (0.000 sec) Query OK, 0 rows affected, 1 warning (0.034 sec) Query OK, 0 rows affected, 1 warning (0.001 sec) Query OK, 0 rows affected, 1 warning (0.025 sec) Query OK, 0 rows affected, 1 warning (0.001 sec) Query OK, 0 rows affected, 1 warning (0.047 sec) Query OK, 5 rows affected (0.005 sec) Records: 5 Duplicates: 0 Warnings: 0 Query OK, 6 rows affected (0.005 sec) Records: 6 Duplicates: 0 Warnings: 0 Query OK, 10 rows affected (0.005 sec) Records: 10 Duplicates: 0 Warnings: 0 Query OK, 3 rows affected (0.005 sec) Records: 3 Duplicates: 0 Warnings: 0 Query OK, 6 rows affected (0.012 sec) Records: 6 Duplicates: 0 Warnings: 0 Query OK, 6 rows affected (0.005 sec) Records: 6 Duplicates: 0 Warnings: 0 Query OK, 9 rows affected (0.006 sec) Records: 9 Duplicates: 0 Warnings: 0 Query OK, 5 rows affected (0.005 sec) Records: 5 Duplicates: 0 Warnings: 0 Query OK, 3 rows affected (0.015 sec) Records: 3 Duplicates: 0 Warnings: 0 Query OK, 11 rows affected (0.013 sec) Records: 11 Duplicates: 0 Warnings: 0 Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.005 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.008 sec) Query OK, 1 row affected (0.005 sec) Query OK, 1 row affected (0.005 sec) Query OK, 1 row affected (0.003 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.005 sec) Query OK, 4 rows affected (0.004 sec) Records: 4 Duplicates: 0 Warnings: 0 Query OK, 1 row affected (0.007 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.005 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 1 row affected (0.004 sec) Query OK, 6 rows affected (0.008 sec) Records: 6 Duplicates: 0 Warnings: 0 Query OK, 3 rows affected (0.004 sec) Records: 3 Duplicates: 0 Warnings: 0 Query OK, 2 rows affected (0.004 sec) Records: 2 Duplicates: 0 Warnings: 0 Query OK, 2 rows affected (0.004 sec) Records: 2 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.000 sec) Query OK, 0 rows affected (0.001 sec) Query OK, 0 rows affected (0.001 sec) MariaDB [SWIM]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | phpmyadmin | | swim | | test | | toyu | +--------------------+ 7 rows in set (0.001 sec) MariaDB [SWIM]> SET @minor = 'CSCI'; Query OK, 0 rows affected (0.000 sec) MariaDB [SWIM]> MariaDB [SWIM]> SELECT @minor; +--------+ | @minor | +--------+ | CSCI | +--------+ 1 row in set (0.000 sec) MariaDB [SWIM]> SELECT * -> FROM student -> WHERE minor = @minor; ERROR 1146 (42S02): Table 'swim.student' doesn't exist MariaDB [SWIM]> use toyu; Database changed MariaDB [toyu]> SELECT * -> FROM student -> WHERE minor = @minor; +--------+-------+-------+-------+-------+------+---------+ | stuId | fname | lname | major | minor | ach | advisor | +--------+-------+-------+-------+-------+------+---------+ | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | +--------+-------+-------+-------+-------+------+---------+ 1 row in set (0.002 sec) MariaDB [toyu]> SELECT * -> FROM t3; +--------+-----------+----------+-------+-------+------+---------+ | 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.002 sec) MariaDB [toyu]> MariaDB [toyu]> CREATE TABLE t5 -> AS SELECT * FROM student; Query OK, 11 rows affected (0.033 sec) Records: 11 Duplicates: 0 Warnings: 0 MariaDB [toyu]> desc t5 -> ; +---------+-------------+------+-----+---------+-------+ | 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) | YES | | 0 | | | advisor | int(11) | YES | | NULL | | +---------+-------------+------+-----+---------+-------+ 7 rows in set (0.012 sec) MariaDB [toyu]> desc 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) | YES | | 0 | | | advisor | int(11) | YES | MUL | NULL | | +---------+-------------+------+-----+---------+-------+ 7 rows in set (0.011 sec) MariaDB [toyu]> MariaDB [toyu]> CREATE TABLE t8 -> LIKE student; Query OK, 0 rows affected (0.030 sec) MariaDB [toyu]> desc t8; +---------+-------------+------+-----+---------+-------+ | 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) | YES | | 0 | | | advisor | int(11) | YES | MUL | NULL | | +---------+-------------+------+-----+---------+-------+ 7 rows in set (0.012 sec) MariaDB [toyu]> MariaDB [toyu]> INSERT INTO t8 -> SELECT * FROM student; Query OK, 11 rows affected (0.007 sec) Records: 11 Duplicates: 0 Warnings: 0 MariaDB [toyu]> SELECT * FROM t8; +--------+-----------+----------+-------+-------+------+---------+ | 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 [toyu]>