Guest
In an insert select have multiple items per line (i.e. by fit); but have the same # of items per line for every line in the insert and select clauses.
i.e.
i.e.
Code:
insert into new_table
(line1_column1, line1_column2,
line2_column1, line2_column2, line2_column3,
line3_column1reallylong, line3_column2reallylong)
select
line1_column1reallylong, line1_column2reallylong,
line2_column1, line2_column2, line2_column3,
line3_column1, line3_column2
from old_table;
Last edited by a moderator:
