Copy entire table

[Frank Thomson]

I would like to copy the entire contents of one table to a second table that has a new id field

new_table will be id plus all the columns of the old table.

if new_table has no fields then this copies all the data OK
INSERT INTO new_table SELECT * FROM original_table;

BUT
if new_table already has the id field then I get an error
mysql error no= 1136: Column count doesn't match value count at row 1

Help appreciated.
Thanks