mysql temporary table join to mysql table code example Example: create temporary table in mysql CREATE TEMPORARY TABLE new_tbl SELECT * FROM orig_tbl LIMIT 0;