Exclude any field from select query

CREATE TEMPORARY TABLE IF NOT EXISTS table2 AS (SELECT * FROM table1);

ALTER TABLE table2 DROP field_name;
SELECT * FROM table2;
DROP TABLE table2;