how to create a temporary table in mysql with select and insert code example

Example: create temporary table in mysql

CREATE TEMPORARY TABLE new_tbl SELECT * FROM orig_tbl LIMIT 0;