Does making a "mini" dataset actually create a new table?

Question

In this exercise, we can make a “mini” dataset like so,

SELECT '2017-01-01' AS 'month'
UNION
SELECT '2017-02-01' AS 'month'

Does this actually create a new table in the database?

Answer

No, this method of making a “mini” dataset will not actually create a new table. Instead, it’s a way to easily create a temporary table, that will disappear after the program runs, without having to actually create one.

In order to create a table, you would need to use the CREATE TABLE statement.

8 Likes