-- 9/25

tee 2024_9_25_sql_log.txt

use toyu;

SELECT stuId
FROM enroll;

SELECT DISTINCT stuId
FROM enroll;

SELECT DISTINCT s.stuId, s.fname
FROM student AS s
WHERE s.lname = 'Hawk';

SELECT DISTINCT s.stuId, s.fname
WHERE s.lname = 'Hawk'
FROM student AS s; -- error


DROP SCHEMA IF EXISTS tinker;
CREATE SCHEMA tinker;
USE tinker;

CREATE TABLE s2 -- creation and population
SELECT * FROM toyu.student;

SELECT *
FROM s2;

CREATE TEMPORARY TABLE s3
SELECT * FROM toyu.student;

SELECT *
FROM s3;

CREATE TABLE s4 LIKE toyu.student; -- creation

SELECT *
FROM s4;

INSERT INTO s4           -- population
SELECT * FROM toyu.student;

SELECT *
FROM s4;

SHOW TABLES;

-- Note that keys and constraints of student are missing in s2 and S3.
DESC toyu.student;
DESC s2;
DESC s4;
DESC s3;
DESC s4;

DROP TABLE s2;
DROP TABLE s3;
DROP TABLE s4;

SHOW TABLES;

DROP SCHEMA IF EXISTS tinker;

UPDATE Student
SET major = 'ITEC'
WHERE StuId = 100000;

UPDATE Student
SET major = 'CSCI';