Skip to main content

CREATE TEMPORARY TABLE

Learn CREATE TEMPORARY TABLE (Temporary Tables, MySQL) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Introduction CREATE TEMPORARY TABLE makes a real table that exists only for your connection. It is invisible to other sessions, is not listed by SHOW TABLES , and is dropped automatically when the session ends. You can create it empty or fill it from a query.

More lessons in Temporary Tables