Re: Insert into select

[Christopher R. Jones]

>insert into foo(a,b) select a1,b1 from bar;
This works great for a small number of fields.  I have two tables, one
slightly different than the other so I can't do:

insert into foo select * from bar;

There are 160 fields to name in the insert statement.  There must be an
example of some smart Perl DBD function someone has used in the past??



Christopher R. Jones, P.Eng.
14 Oneida Avenue
Toronto, Ontario M5J 2E3
Tel. [phone]
Fax. [phone]
Email cj@stripped