I want to use INSERT INTO SELECT *
to insert data into a dest table from a source table, but I have some extra columns added to destination table. These columns are distributed around the table like 2 are at top and 2 are at bottom.
Also for insertion I can insert some default value like null to these columns.