MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | ctetinker | | dbtool | | ds | | information_schema | | mysql | | performance_schema | | phpmyadmin | | swim | | toyu | +--------------------+ 9 rows in set (0.003 sec) MariaDB [(none)]> MariaDB [(none)]> SELECT * FROM student; ERROR 1046 (3D000): No database selected MariaDB [(none)]> MariaDB [(none)]> SELECT stuId, fname, lname, major -> FROM student; ERROR 1046 (3D000): No database selected MariaDB [(none)]> 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.001 sec) MariaDB [toyu]> MariaDB [toyu]> SELECT stuId, fname, lname, major -> FROM student; +--------+-----------+----------+-------+ | stuId | fname | lname | major | +--------+-----------+----------+-------+ | 100000 | Tony | Hawk | CSCI | | 100001 | Mary | Hawk | CSCI | | 100002 | David | Hawk | CSCI | | 100003 | Catherine | Lim | ITEC | | 100004 | Larry | Johnson | ITEC | | 100005 | Linda | Johnson | CINF | | 100006 | Lillian | Johnson | CINF | | 100007 | Ben | Zico | NULL | | 100008 | Bill | Ching | ARTS | | 100009 | Linda | King | ARTS | | 100111 | Cathy | Johanson | NULL | +--------+-----------+----------+-------+ 11 rows in set (0.000 sec) MariaDB [toyu]> MariaDB [toyu]> SELECT * -> FROM student -> WHERE stuId = 100000; +--------+-------+-------+-------+-------+------+---------+ | stuId | fname | lname | major | minor | ach | advisor | +--------+-------+-------+-------+-------+------+---------+ | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | +--------+-------+-------+-------+-------+------+---------+ 1 row in set (0.001 sec) MariaDB [toyu]> SELECT * -> FROM enroll -> WHERE stuId = 100000; +--------+---------+-------+----------+ | stuId | classId | grade | n_alerts | +--------+---------+-------+----------+ | 100000 | 10000 | A | 0 | | 100000 | 10001 | A | 2 | | 100000 | 10002 | B+ | 1 | | 100000 | 10003 | C | 0 | | 100000 | 10004 | A- | 1 | | 100000 | 11001 | D | 4 | +--------+---------+-------+----------+ 6 rows in set (0.001 sec) MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (100000,'Bun','Yue','CSCI','CITEC',22,1011); ERROR 1062 (23000): Duplicate entry '100000' for key 'PRIMARY' MariaDB [toyu]> MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (222000,'Bun','Yue','CSCI','CITEC',22,1011); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`toyu`.`student`, CONSTRAINT `Student_minor_fk` FOREIGN KEY (`minor`) REFERENCES `department` (`deptCode`) ON DELETE CASCADE) MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (222000,'Bun','Yue','CSCI','ITEC',22,1011); Query OK, 1 row affected (0.006 sec) MariaDB [toyu]> SELECT * -> FROM enroll -> WHERE sclassId =10000; ERROR 1054 (42S22): Unknown column 'sclassId' in 'where clause' MariaDB [toyu]> SELECT * -> FROM enroll -> WHERE classId =10000; +--------+---------+-------+----------+ | stuId | classId | grade | n_alerts | +--------+---------+-------+----------+ | 100000 | 10000 | A | 0 | | 100001 | 10000 | NULL | NULL | | 100002 | 10000 | B- | 3 | +--------+---------+-------+----------+ 3 rows in set (0.001 sec) MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (333000,'Bun007','Yue','SECR','ITEC',32,1011); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`toyu`.`student`, CONSTRAINT `Student_major_fk` FOREIGN KEY (`major`) REFERENCES `department` (`deptCode`) ON DELETE CASCADE) MariaDB [toyu]> INSERT INTO Department(deptCode, deptName, schoolCode, numStaff) VALUES -> ('SECR','Secret Agent','CSE',100); Query OK, 1 row affected (0.007 sec) MariaDB [toyu]> SELECT * FROM department; +----------+------------------------------+------------+----------+ | deptCode | deptName | schoolCode | numStaff | +----------+------------------------------+------------+----------+ | ACCT | Accounting | BUS | 10 | | ARTS | Arts | HSH | 5 | | CINF | Computer Information Systems | CSE | 5 | | CSCI | Computer Science | CSE | 12 | | ENGL | English | HSH | 12 | | ITEC | Information Technology | CSE | 4 | | MATH | Mathematics | CSE | 7 | | SECR | Secret Agent | CSE | 100 | +----------+------------------------------+------------+----------+ 8 rows in set (0.000 sec) MariaDB [toyu]> MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (333000,'Bun007','Yue','SECR','ITEC',32,1011); Query OK, 1 row affected (0.006 sec) MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (333000,'Bun117','Yue','SECR','MUSI',32,2222); ERROR 1062 (23000): Duplicate entry '333000' for key 'PRIMARY' MariaDB [toyu]> MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (444000,'Bun117','Yue','SECR','MUSI',32,2222); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`toyu`.`student`, CONSTRAINT `Student_minor_fk` FOREIGN KEY (`minor`) REFERENCES `department` (`deptCode`) ON DELETE CASCADE) MariaDB [toyu]> INSERT INTO Department(deptCode, deptName, schoolCode, numStaff) VALUES -> ('MUSI','Music','COB',1); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`toyu`.`department`, CONSTRAINT `Department_schoolCode_fk` FOREIGN KEY (`schoolCode`) REFERENCES `school` (`schoolCode`)) MariaDB [toyu]> MariaDB [toyu]> INSERT INTO Department(deptCode, deptName, schoolCode, numStaff) VALUES -> ('MUSI','Music','BUS',1); Query OK, 1 row affected (0.006 sec) MariaDB [toyu]> MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (444000,'Bun117','Yue','SECR','MUSI',32,2222); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`toyu`.`student`, CONSTRAINT `Student_advisor_fk` FOREIGN KEY (`advisor`) REFERENCES `faculty` (`facId`)) MariaDB [toyu]> INSERT INTO Faculty(facId, fname, lname, deptCode, `rank`) VALUES -> (2222,'Linda','Smith','MUSI','Professor'); Query OK, 1 row affected (0.004 sec) MariaDB [toyu]> INSERT INTO Student(stuId, fname, lname, major, minor, ach, advisor) VALUES -> (444000,'Bun117','Yue','SECR','MUSI',32,2222); Query OK, 1 row affected (0.005 sec) MariaDB [toyu]> SELECT DISTINCT s.*, e.* -- [2] -> FROM student AS s, enroll AS e; -- [1] create the 'big' table +--------+-----------+----------+-------+-------+------+---------+--------+---------+-------+----------+ | stuId | fname | lname | major | minor | ach | advisor | stuId | classId | grade | n_alerts | +--------+-----------+----------+-------+-------+------+---------+--------+---------+-------+----------+ | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10000 | A | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100000 | 10000 | A | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100000 | 10000 | A | 0 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100000 | 10000 | A | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100000 | 10000 | A | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100000 | 10000 | A | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100000 | 10000 | A | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100000 | 10000 | A | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100000 | 10000 | A | 0 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100000 | 10000 | A | 0 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100000 | 10000 | A | 0 | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100000 | 10000 | A | 0 | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100000 | 10000 | A | 0 | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100000 | 10000 | A | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100001 | 10000 | NULL | NULL | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10000 | NULL | NULL | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100001 | 10000 | NULL | NULL | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100001 | 10000 | NULL | NULL | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100001 | 10000 | NULL | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100001 | 10000 | NULL | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100001 | 10000 | NULL | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100001 | 10000 | NULL | NULL | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100001 | 10000 | NULL | NULL | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100001 | 10000 | NULL | NULL | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100001 | 10000 | NULL | NULL | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100001 | 10000 | NULL | NULL | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100001 | 10000 | NULL | NULL | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100001 | 10000 | NULL | NULL | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100002 | 10000 | B- | 3 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100002 | 10000 | B- | 3 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10000 | B- | 3 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100002 | 10000 | B- | 3 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100002 | 10000 | B- | 3 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100002 | 10000 | B- | 3 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100002 | 10000 | B- | 3 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100002 | 10000 | B- | 3 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100002 | 10000 | B- | 3 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100002 | 10000 | B- | 3 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100002 | 10000 | B- | 3 | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100002 | 10000 | B- | 3 | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100002 | 10000 | B- | 3 | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100002 | 10000 | B- | 3 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10001 | A | 2 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100000 | 10001 | A | 2 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100000 | 10001 | A | 2 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100000 | 10001 | A | 2 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100000 | 10001 | A | 2 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100000 | 10001 | A | 2 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100000 | 10001 | A | 2 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100000 | 10001 | A | 2 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100000 | 10001 | A | 2 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100000 | 10001 | A | 2 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100000 | 10001 | A | 2 | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100000 | 10001 | A | 2 | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100000 | 10001 | A | 2 | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100000 | 10001 | A | 2 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100001 | 10001 | A- | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10001 | A- | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100001 | 10001 | A- | 0 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100001 | 10001 | A- | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100001 | 10001 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100001 | 10001 | A- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100001 | 10001 | A- | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100001 | 10001 | A- | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100001 | 10001 | A- | 0 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100001 | 10001 | A- | 0 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100001 | 10001 | A- | 0 | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100001 | 10001 | A- | 0 | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100001 | 10001 | A- | 0 | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100001 | 10001 | A- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10002 | B+ | 1 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100000 | 10002 | B+ | 1 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100000 | 10002 | B+ | 1 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100000 | 10002 | B+ | 1 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100000 | 10002 | B+ | 1 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100000 | 10002 | B+ | 1 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100000 | 10002 | B+ | 1 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100000 | 10002 | B+ | 1 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100000 | 10002 | B+ | 1 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100000 | 10002 | B+ | 1 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100000 | 10002 | B+ | 1 | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100000 | 10002 | B+ | 1 | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100000 | 10002 | B+ | 1 | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100000 | 10002 | B+ | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100002 | 10002 | B+ | 2 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100002 | 10002 | B+ | 2 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10002 | B+ | 2 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100002 | 10002 | B+ | 2 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100002 | 10002 | B+ | 2 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100002 | 10002 | B+ | 2 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100002 | 10002 | B+ | 2 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100002 | 10002 | B+ | 2 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100002 | 10002 | B+ | 2 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100002 | 10002 | B+ | 2 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100002 | 10002 | B+ | 2 | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100002 | 10002 | B+ | 2 | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100002 | 10002 | B+ | 2 | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100002 | 10002 | B+ | 2 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10003 | C | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100000 | 10003 | C | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100000 | 10003 | C | 0 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100000 | 10003 | C | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100000 | 10003 | C | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100000 | 10003 | C | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100000 | 10003 | C | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100000 | 10003 | C | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100000 | 10003 | C | 0 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100000 | 10003 | C | 0 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100000 | 10003 | C | 0 | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100000 | 10003 | C | 0 | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100000 | 10003 | C | 0 | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100000 | 10003 | C | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100002 | 10003 | D | 4 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100002 | 10003 | D | 4 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10003 | D | 4 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100002 | 10003 | D | 4 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100002 | 10003 | D | 4 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100002 | 10003 | D | 4 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100002 | 10003 | D | 4 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100002 | 10003 | D | 4 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100002 | 10003 | D | 4 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100002 | 10003 | D | 4 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100002 | 10003 | D | 4 | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100002 | 10003 | D | 4 | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100002 | 10003 | D | 4 | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100002 | 10003 | D | 4 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100004 | 10003 | A | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100004 | 10003 | A | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100004 | 10003 | A | 0 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100004 | 10003 | A | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10003 | A | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100004 | 10003 | A | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100004 | 10003 | A | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100004 | 10003 | A | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100004 | 10003 | A | 0 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100004 | 10003 | A | 0 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100004 | 10003 | A | 0 | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100004 | 10003 | A | 0 | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100004 | 10003 | A | 0 | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100004 | 10003 | A | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100005 | 10003 | NULL | NULL | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100005 | 10003 | NULL | NULL | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100005 | 10003 | NULL | NULL | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100005 | 10003 | NULL | NULL | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100005 | 10003 | NULL | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10003 | NULL | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100005 | 10003 | NULL | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100005 | 10003 | NULL | NULL | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100005 | 10003 | NULL | NULL | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100005 | 10003 | NULL | NULL | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100005 | 10003 | NULL | NULL | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100005 | 10003 | NULL | NULL | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100005 | 10003 | NULL | NULL | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100005 | 10003 | NULL | NULL | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10004 | A- | 1 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100000 | 10004 | A- | 1 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100000 | 10004 | A- | 1 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100000 | 10004 | A- | 1 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100000 | 10004 | A- | 1 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100000 | 10004 | A- | 1 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100000 | 10004 | A- | 1 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100000 | 10004 | A- | 1 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100000 | 10004 | A- | 1 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100000 | 10004 | A- | 1 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100000 | 10004 | A- | 1 | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100000 | 10004 | A- | 1 | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100000 | 10004 | A- | 1 | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100000 | 10004 | A- | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100004 | 10004 | B+ | NULL | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100004 | 10004 | B+ | NULL | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100004 | 10004 | B+ | NULL | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100004 | 10004 | B+ | NULL | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10004 | B+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100004 | 10004 | B+ | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100004 | 10004 | B+ | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100004 | 10004 | B+ | NULL | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100004 | 10004 | B+ | NULL | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100004 | 10004 | B+ | NULL | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100004 | 10004 | B+ | NULL | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100004 | 10004 | B+ | NULL | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100004 | 10004 | B+ | NULL | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100004 | 10004 | B+ | NULL | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100005 | 10004 | A- | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100005 | 10004 | A- | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100005 | 10004 | A- | 0 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100005 | 10004 | A- | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100005 | 10004 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10004 | A- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100005 | 10004 | A- | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100005 | 10004 | A- | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100005 | 10004 | A- | 0 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100005 | 10004 | A- | 0 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100005 | 10004 | A- | 0 | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100005 | 10004 | A- | 0 | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100005 | 10004 | A- | 0 | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100005 | 10004 | A- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100006 | 10004 | C+ | NULL | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100006 | 10004 | C+ | NULL | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100006 | 10004 | C+ | NULL | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100006 | 10004 | C+ | NULL | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100006 | 10004 | C+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100006 | 10004 | C+ | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10004 | C+ | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100006 | 10004 | C+ | NULL | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100006 | 10004 | C+ | NULL | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100006 | 10004 | C+ | NULL | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100006 | 10004 | C+ | NULL | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100006 | 10004 | C+ | NULL | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100006 | 10004 | C+ | NULL | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100006 | 10004 | C+ | NULL | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100005 | 10005 | A- | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100005 | 10005 | A- | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100005 | 10005 | A- | 0 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100005 | 10005 | A- | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100005 | 10005 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10005 | A- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100005 | 10005 | A- | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100005 | 10005 | A- | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100005 | 10005 | A- | 0 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100005 | 10005 | A- | 0 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100005 | 10005 | A- | 0 | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100005 | 10005 | A- | 0 | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100005 | 10005 | A- | 0 | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100005 | 10005 | A- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100006 | 10005 | A | NULL | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100006 | 10005 | A | NULL | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100006 | 10005 | A | NULL | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100006 | 10005 | A | NULL | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100006 | 10005 | A | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100006 | 10005 | A | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10005 | A | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100006 | 10005 | A | NULL | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100006 | 10005 | A | NULL | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100006 | 10005 | A | NULL | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100006 | 10005 | A | NULL | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100006 | 10005 | A | NULL | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100006 | 10005 | A | NULL | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100006 | 10005 | A | NULL | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100005 | 10006 | B+ | NULL | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100005 | 10006 | B+ | NULL | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100005 | 10006 | B+ | NULL | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100005 | 10006 | B+ | NULL | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100005 | 10006 | B+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10006 | B+ | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100005 | 10006 | B+ | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100005 | 10006 | B+ | NULL | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100005 | 10006 | B+ | NULL | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100005 | 10006 | B+ | NULL | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100005 | 10006 | B+ | NULL | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100005 | 10006 | B+ | NULL | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100005 | 10006 | B+ | NULL | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100005 | 10006 | B+ | NULL | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100007 | 10007 | F | 4 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100007 | 10007 | F | 4 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100007 | 10007 | F | 4 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100007 | 10007 | F | 4 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100007 | 10007 | F | 4 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100007 | 10007 | F | 4 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100007 | 10007 | F | 4 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10007 | F | 4 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100007 | 10007 | F | 4 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100007 | 10007 | F | 4 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100007 | 10007 | F | 4 | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100007 | 10007 | F | 4 | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100007 | 10007 | F | 4 | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100007 | 10007 | F | 4 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100008 | 10007 | C- | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100008 | 10007 | C- | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100008 | 10007 | C- | 0 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100008 | 10007 | C- | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100008 | 10007 | C- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100008 | 10007 | C- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100008 | 10007 | C- | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100008 | 10007 | C- | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100008 | 10007 | C- | 0 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100008 | 10007 | C- | 0 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100008 | 10007 | C- | 0 | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100008 | 10007 | C- | 0 | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100008 | 10007 | C- | 0 | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100008 | 10007 | C- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100007 | 10008 | A- | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100007 | 10008 | A- | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100007 | 10008 | A- | 0 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100007 | 10008 | A- | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100007 | 10008 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100007 | 10008 | A- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100007 | 10008 | A- | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10008 | A- | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100007 | 10008 | A- | 0 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100007 | 10008 | A- | 0 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100007 | 10008 | A- | 0 | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100007 | 10008 | A- | 0 | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100007 | 10008 | A- | 0 | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100007 | 10008 | A- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 11001 | D | 4 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100000 | 11001 | D | 4 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100000 | 11001 | D | 4 | | 100003 | Catherine | Lim | ITEC | CINF | 20 | NULL | 100000 | 11001 | D | 4 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100000 | 11001 | D | 4 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100000 | 11001 | D | 4 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100000 | 11001 | D | 4 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100000 | 11001 | D | 4 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100000 | 11001 | D | 4 | | 100009 | Linda | King | ARTS | CSCI | 125 | 1018 | 100000 | 11001 | D | 4 | | 100111 | Cathy | Johanson | NULL | NULL | 0 | 1018 | 100000 | 11001 | D | 4 | | 222000 | Bun | Yue | CSCI | ITEC | 22 | 1011 | 100000 | 11001 | D | 4 | | 333000 | Bun007 | Yue | SECR | ITEC | 32 | 1011 | 100000 | 11001 | D | 4 | | 444000 | Bun117 | Yue | SECR | MUSI | 32 | 2222 | 100000 | 11001 | D | 4 | +--------+-----------+----------+-------+-------+------+---------+--------+---------+-------+----------+ 308 rows in set (0.002 sec) MariaDB [toyu]> SELECT DISTINCT s.*, e.* -- [2] -> FROM student AS s, enroll AS e -- [1] create the 'big' table -> WHERE s.stuId = e.stuId; +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ | stuId | fname | lname | major | minor | ach | advisor | stuId | classId | grade | n_alerts | +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10000 | A | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10000 | NULL | NULL | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10000 | B- | 3 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10001 | A | 2 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10001 | A- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10002 | B+ | 1 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10002 | B+ | 2 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10003 | C | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10003 | D | 4 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10003 | A | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10003 | NULL | NULL | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10004 | A- | 1 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10004 | B+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10004 | A- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10004 | C+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10005 | A- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10005 | A | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10006 | B+ | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10007 | F | 4 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100008 | 10007 | C- | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10008 | A- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 11001 | D | 4 | +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ 22 rows in set (0.001 sec) MariaDB [toyu]> MariaDB [toyu]> SELECT DISTINCT s.*, e.* -- [2] -> FROM student AS s INNER JOIN enroll AS e ON (s.stuId = e.stuId) -> ; -- [1] create the 'big' table +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ | stuId | fname | lname | major | minor | ach | advisor | stuId | classId | grade | n_alerts | +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10000 | A | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10000 | NULL | NULL | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10000 | B- | 3 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10001 | A | 2 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10001 | A- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10002 | B+ | 1 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10002 | B+ | 2 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10003 | C | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10003 | D | 4 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10003 | A | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10003 | NULL | NULL | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10004 | A- | 1 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10004 | B+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10004 | A- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10004 | C+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10005 | A- | 0 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10005 | A | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10006 | B+ | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10007 | F | 4 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100008 | 10007 | C- | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10008 | A- | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 11001 | D | 4 | +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ 22 rows in set (0.001 sec) MariaDB [toyu]> SELECT DISTINCT s.*, e.* -- [2] -> FROM student AS s INNER JOIN enroll AS e ON (s.stuId = e.stuId) -- [1] create the 'big' table -> WHERE s.minor = 'CINF' OR s.minor = 'ITEC'; -- [2] +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ | stuId | fname | lname | major | minor | ach | advisor | stuId | classId | grade | n_alerts | +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10000 | A | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10001 | A | 2 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10002 | B+ | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10003 | C | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10004 | A- | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 11001 | D | 4 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10000 | NULL | NULL | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10001 | A- | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10000 | B- | 3 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10002 | B+ | 2 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10003 | D | 4 | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10004 | C+ | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10005 | A | NULL | +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+ 13 rows in set (0.001 sec) MariaDB [toyu]> MariaDB [toyu]> SELECT DISTINCT s.fname, s.lname, e.classId, e.grade-- [3] construct from [2] filtered table -> FROM student AS s INNER JOIN enroll AS e ON (s.stuId = e.stuId) -- [1] create the 'big' table -> WHERE s.minor = 'CINF' OR s.minor = 'ITEC'; -- [2] filter the big table +---------+---------+---------+-------+ | fname | lname | classId | grade | +---------+---------+---------+-------+ | Tony | Hawk | 10000 | A | | Tony | Hawk | 10001 | A | | Tony | Hawk | 10002 | B+ | | Tony | Hawk | 10003 | C | | Tony | Hawk | 10004 | A- | | Tony | Hawk | 11001 | D | | Mary | Hawk | 10000 | NULL | | Mary | Hawk | 10001 | A- | | David | Hawk | 10000 | B- | | David | Hawk | 10002 | B+ | | David | Hawk | 10003 | D | | Lillian | Johnson | 10004 | C+ | | Lillian | Johnson | 10005 | A | +---------+---------+---------+-------+ 13 rows in set (0.002 sec) MariaDB [toyu]> SELECT DISTINCT s.stuId, -> CONCAT(s.fname, ' ', s.lname) AS student, e.classId, e.grade-- [3] construct from [2] filtered table -> FROM student AS s INNER JOIN enroll AS e ON (s.stuId = e.stuId) -- [1] create the 'big' table -> WHERE s.minor = 'CINF' OR s.minor = 'ITEC'; -- [2] filter the big table +--------+-----------------+---------+-------+ | stuId | student | classId | grade | +--------+-----------------+---------+-------+ | 100000 | Tony Hawk | 10000 | A | | 100000 | Tony Hawk | 10001 | A | | 100000 | Tony Hawk | 10002 | B+ | | 100000 | Tony Hawk | 10003 | C | | 100000 | Tony Hawk | 10004 | A- | | 100000 | Tony Hawk | 11001 | D | | 100001 | Mary Hawk | 10000 | NULL | | 100001 | Mary Hawk | 10001 | A- | | 100002 | David Hawk | 10000 | B- | | 100002 | David Hawk | 10002 | B+ | | 100002 | David Hawk | 10003 | D | | 100006 | Lillian Johnson | 10004 | C+ | | 100006 | Lillian Johnson | 10005 | A | +--------+-----------------+---------+-------+ 13 rows in set (0.001 sec) MariaDB [toyu]> SELECT DISTINCT e.stuId -> FROM enroll AS e; +--------+ | stuId | +--------+ | 100000 | | 100001 | | 100002 | | 100004 | | 100005 | | 100006 | | 100007 | | 100008 | +--------+ 8 rows in set (0.001 sec) MariaDB [toyu]> SELECT DISTINCT s.fname, s.lname -> FROM student AS s INNER JOIN enroll AS e ON (s.stuId = e.stuId); +---------+---------+ | fname | lname | +---------+---------+ | Tony | Hawk | | Mary | Hawk | | David | Hawk | | Larry | Johnson | | Linda | Johnson | | Lillian | Johnson | | Ben | Zico | | Bill | Ching | +---------+---------+ 8 rows in set (0.001 sec) MariaDB [toyu]> SELECT DISTINCT s.stuId, s.fname, s.lname -> FROM student AS s INNER JOIN enroll AS e ON (s.stuId = e.stuId); +--------+---------+---------+ | stuId | fname | lname | +--------+---------+---------+ | 100000 | Tony | Hawk | | 100001 | Mary | Hawk | | 100002 | David | Hawk | | 100004 | Larry | Johnson | | 100005 | Linda | Johnson | | 100006 | Lillian | Johnson | | 100007 | Ben | Zico | | 100008 | Bill | Ching | +--------+---------+---------+ 8 rows in set (0.001 sec) MariaDB [toyu]> SELECT DISTINCT s.stuId, s.fname, s.lname -> FROM student AS s INNER JOIN enroll AS e ON (s.stuId = e.stuId) -> INNER JOIN enroll AS e ON (s.stuId = e.stuId); ERROR 1066 (42000): Not unique table/alias: 'e' MariaDB [toyu]> MariaDB [toyu]> SELECT DISTINCT s.stuId, s.fname, s.lname -> FROM student AS s INNER JOIN enroll AS e1 ON (s.stuId = e1.stuId) -> INNER JOIN enroll AS e2 ON (s.stuId = e2.stuId); +--------+---------+---------+ | stuId | fname | lname | +--------+---------+---------+ | 100000 | Tony | Hawk | | 100001 | Mary | Hawk | | 100002 | David | Hawk | | 100004 | Larry | Johnson | | 100005 | Linda | Johnson | | 100006 | Lillian | Johnson | | 100007 | Ben | Zico | | 100008 | Bill | Ching | +--------+---------+---------+ 8 rows in set (0.002 sec) MariaDB [toyu]> SELECT DISTINCT s.*, e1.*, e2.* -> FROM student AS s INNER JOIN enroll AS e1 ON (s.stuId = e1.stuId) -> INNER JOIN enroll AS e2 ON (s.stuId = e2.stuId); +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+--------+---------+-------+----------+ | stuId | fname | lname | major | minor | ach | advisor | stuId | classId | grade | n_alerts | stuId | classId | grade | n_alerts | +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+--------+---------+-------+----------+ | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10000 | A | 0 | 100000 | 10000 | A | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10000 | A | 0 | 100000 | 10001 | A | 2 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10000 | A | 0 | 100000 | 10002 | B+ | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10000 | A | 0 | 100000 | 10003 | C | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10000 | A | 0 | 100000 | 10004 | A- | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10000 | A | 0 | 100000 | 11001 | D | 4 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10001 | A | 2 | 100000 | 10000 | A | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10001 | A | 2 | 100000 | 10001 | A | 2 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10001 | A | 2 | 100000 | 10002 | B+ | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10001 | A | 2 | 100000 | 10003 | C | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10001 | A | 2 | 100000 | 10004 | A- | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10001 | A | 2 | 100000 | 11001 | D | 4 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10002 | B+ | 1 | 100000 | 10000 | A | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10002 | B+ | 1 | 100000 | 10001 | A | 2 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10002 | B+ | 1 | 100000 | 10002 | B+ | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10002 | B+ | 1 | 100000 | 10003 | C | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10002 | B+ | 1 | 100000 | 10004 | A- | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10002 | B+ | 1 | 100000 | 11001 | D | 4 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10003 | C | 0 | 100000 | 10000 | A | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10003 | C | 0 | 100000 | 10001 | A | 2 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10003 | C | 0 | 100000 | 10002 | B+ | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10003 | C | 0 | 100000 | 10003 | C | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10003 | C | 0 | 100000 | 10004 | A- | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10003 | C | 0 | 100000 | 11001 | D | 4 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10004 | A- | 1 | 100000 | 10000 | A | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10004 | A- | 1 | 100000 | 10001 | A | 2 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10004 | A- | 1 | 100000 | 10002 | B+ | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10004 | A- | 1 | 100000 | 10003 | C | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10004 | A- | 1 | 100000 | 10004 | A- | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 10004 | A- | 1 | 100000 | 11001 | D | 4 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 11001 | D | 4 | 100000 | 10000 | A | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 11001 | D | 4 | 100000 | 10001 | A | 2 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 11001 | D | 4 | 100000 | 10002 | B+ | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 11001 | D | 4 | 100000 | 10003 | C | 0 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 11001 | D | 4 | 100000 | 10004 | A- | 1 | | 100000 | Tony | Hawk | CSCI | CINF | 40 | 1011 | 100000 | 11001 | D | 4 | 100000 | 11001 | D | 4 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10000 | NULL | NULL | 100001 | 10000 | NULL | NULL | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10000 | NULL | NULL | 100001 | 10001 | A- | 0 | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10001 | A- | 0 | 100001 | 10000 | NULL | NULL | | 100001 | Mary | Hawk | CSCI | CINF | 35 | 1011 | 100001 | 10001 | A- | 0 | 100001 | 10001 | A- | 0 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10000 | B- | 3 | 100002 | 10000 | B- | 3 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10000 | B- | 3 | 100002 | 10002 | B+ | 2 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10000 | B- | 3 | 100002 | 10003 | D | 4 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10002 | B+ | 2 | 100002 | 10000 | B- | 3 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10002 | B+ | 2 | 100002 | 10002 | B+ | 2 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10002 | B+ | 2 | 100002 | 10003 | D | 4 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10003 | D | 4 | 100002 | 10000 | B- | 3 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10003 | D | 4 | 100002 | 10002 | B+ | 2 | | 100002 | David | Hawk | CSCI | ITEC | 66 | 1012 | 100002 | 10003 | D | 4 | 100002 | 10003 | D | 4 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10003 | A | 0 | 100004 | 10003 | A | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10003 | A | 0 | 100004 | 10004 | B+ | NULL | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10004 | B+ | NULL | 100004 | 10003 | A | 0 | | 100004 | Larry | Johnson | ITEC | NULL | 66 | 1017 | 100004 | 10004 | B+ | NULL | 100004 | 10004 | B+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10003 | NULL | NULL | 100005 | 10003 | NULL | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10003 | NULL | NULL | 100005 | 10004 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10003 | NULL | NULL | 100005 | 10005 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10003 | NULL | NULL | 100005 | 10006 | B+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10004 | A- | 0 | 100005 | 10003 | NULL | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10004 | A- | 0 | 100005 | 10004 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10004 | A- | 0 | 100005 | 10005 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10004 | A- | 0 | 100005 | 10006 | B+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10005 | A- | 0 | 100005 | 10003 | NULL | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10005 | A- | 0 | 100005 | 10004 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10005 | A- | 0 | 100005 | 10005 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10005 | A- | 0 | 100005 | 10006 | B+ | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10006 | B+ | NULL | 100005 | 10003 | NULL | NULL | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10006 | B+ | NULL | 100005 | 10004 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10006 | B+ | NULL | 100005 | 10005 | A- | 0 | | 100005 | Linda | Johnson | CINF | ENGL | 13 | 1015 | 100005 | 10006 | B+ | NULL | 100005 | 10006 | B+ | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10004 | C+ | NULL | 100006 | 10004 | C+ | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10004 | C+ | NULL | 100006 | 10005 | A | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10005 | A | NULL | 100006 | 10004 | C+ | NULL | | 100006 | Lillian | Johnson | CINF | ITEC | 18 | 1016 | 100006 | 10005 | A | NULL | 100006 | 10005 | A | NULL | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10007 | F | 4 | 100007 | 10007 | F | 4 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10007 | F | 4 | 100007 | 10008 | A- | 0 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10008 | A- | 0 | 100007 | 10007 | F | 4 | | 100007 | Ben | Zico | NULL | NULL | 16 | NULL | 100007 | 10008 | A- | 0 | 100007 | 10008 | A- | 0 | | 100008 | Bill | Ching | ARTS | NULL | 90 | NULL | 100008 | 10007 | C- | 0 | 100008 | 10007 | C- | 0 | +--------+---------+---------+-------+-------+------+---------+--------+---------+-------+----------+--------+---------+-------+----------+ 78 rows in set (0.003 sec) MariaDB [toyu]> MariaDB [toyu]> SELECT DISTINCT s.stuId, s.fname, s.lname -> FROM student AS s INNER JOIN enroll AS e1 ON (s.stuId = e1.stuId) -> INNER JOIN enroll AS e2 ON (s.stuId = e2.stuId) -> WHERE e1.classId <> e2.classId; +--------+---------+---------+ | stuId | fname | lname | +--------+---------+---------+ | 100000 | Tony | Hawk | | 100001 | Mary | Hawk | | 100002 | David | Hawk | | 100004 | Larry | Johnson | | 100005 | Linda | Johnson | | 100006 | Lillian | Johnson | | 100007 | Ben | Zico | +--------+---------+---------+ 7 rows in set (0.001 sec) MariaDB [toyu]> MariaDB [toyu]> SELECT DISTINCT s.stuId, s.fname, s.lname -> FROM student AS s INNER JOIN enroll AS e ON (s.stuId = e.stuId AND e.classId >= 2) -> ; +--------+---------+---------+ | stuId | fname | lname | +--------+---------+---------+ | 100000 | Tony | Hawk | | 100001 | Mary | Hawk | | 100002 | David | Hawk | | 100004 | Larry | Johnson | | 100005 | Linda | Johnson | | 100006 | Lillian | Johnson | | 100007 | Ben | Zico | | 100008 | Bill | Ching | +--------+---------+---------+ 8 rows in set (0.001 sec) MariaDB [toyu]> notee