The MySQL syntax offers several ways to avoid repeating names in a table and to. ... For example, type "CREATE TEMPORARY TABLE employees" if you plan to drop the table soon after creating it.