CREATE TABET t1
(x INT);

CREATE SCHEMA tinker;
use tinker;


CREATE TABLE s2
SELECT * FROM toyu.student;

SELECT *
FROM s2;

CREATE TEMPORARY TABLE s3
SELECT * FROM toyu.student;


SET @major = 'CSCI';

SELECT *
FROM s3;

CREATE TABLE s4 LIKE student;


SELECT s.*
FROM toyu.student AS s
WHERE s.major = @major;


SELECT *
FROM s4;

INSERT INTO s4
SELECT * FROM student;

SELECT *
FROM s4;

SHOW TABLES;

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

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

SHOW TABLES;

use toyu;

SELECT * FROM student;

DELETE FROM student
WHERE 1;