There are two ways to make a temporary table. Using an INTO statement within a select query is the simplest way to create a temporary table. Let’s make a temporary table with all of the male student records from the student table’s names, age, and gender.