MySql table creation

1. Can create temporary tables. 
• create temporary table foo (id numeric);
• These tables are not shown with the command show tables;
2. Can create tables that are structurally identical to other tables
• create table temp_instructor like instructor;
• create temporary table temp_instructor like instructor;
3. Can create tables "on the fly" using the results of a query
• create table foo as (select id from instructor);
• create temporary table foo as (select id, salary from instructor);