run mysql create table by select another and copied the indexes automatically

Question

i want to run a query like this :

CREATE TABLE newtable SELECT * FROM oldtable

its work fine

but the indexes not copied to the new table ,

how can i run the query and prevent the indexes ?

thanks

Answer 1

create table newtable like oldtable; 
insert newtable select * from oldtable