-- 9/25

tee 2024_9_25_sql_log.txt

SELECT stuId
FROM enroll;


SELECT DISTINCT stuId
FROM enroll;

SELECT DISTINCT f.facId, f.lname
FROM faculty AS f
WHERE rank = 'Professor';

SELECT DISTINCT f.facId, f.lname
WHERE rank = 'Professor'
FROM faculty AS f;



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

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

SELECT *
FROM s2;

CREATE TEMPORARY TABLE s3
SELECT * FROM toyu.student;

SELECT *
FROM s3;

-- CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name
 --   { LIKE old_tbl_name | (LIKE old_tbl_name) }
CREATE TABLE s4 LIKE toyu.student; -- creation of table

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;

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

SHOW TABLES;

DROP SCHEMA IF EXISTS tinker;

UPDATE [LOW_PRIORITY] [IGNORE] table_reference
    SET assignment_list
    [WHERE where_condition]
    [ORDER BY ...]
    [LIMIT row_count]
    
UPDATE Student
SET major = 'ITEC'
WHERE StuId = 100000;

UPDATE Student
SET major = 'CSCI';