Advanced-MySQL-Course/2.4 Temporary Tables.sql at main · AnalystBuilder/Advanced-MySQL-Course · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
-- Using Temporary Tables


CREATE TEMPORARY TABLE temp_table
(first_name varchar(50),
last_name varchar(50),
favorite_movie varchar(100)
);

SELECT *
FROM temp_table;

INSERT INTO temp_table
VALUES ('Alex','Freberg','Lord of the Rings: Two Towers');


SELECT *
FROM temp_table;

SELECT *
FROM temp_table;


CREATE TEMPORARY TABLE temp_table2
SELECT *
FROM employees
WHERE salary > 50000;


SELECT *
FROM temp_table2;