mysql insert from temporary table code example

Example: create temporary table in mysql

CREATE TEMPORARY TABLE new_tbl SELECT * FROM orig_tbl LIMIT 0;