Do not copy. Create...

[Владислав Сокол]

Do not copy. Do not create new table separately at all. Use CREATE .. SELECT and define only columns which are absent in source table:

CREATE TABLE new_table (id INT AUTO_INCREMENT PRIMARY KEY)
SELECT * FROM old_table;

You can see this method on this demo fiddle: https://dbfiddle.uk/?rdbms=mysql_8.0&fiddle=e87757fd195a22d261a08736e90df949