/*create a copy of a table so that you
can alter it or experiment with it without endangering the original
data
*/
CREATE TABLE new_table_name
SELECT * FROM old_table_name;
/* Differences: their names,
if the old table had an index (or key), it
does not transfer to the new table.
only two columns chosen
*/