List:General Discussion« Previous MessageNext Message »
From:Christopher R. Jones Date:April 28 2000 7:24pm
Subject:Re: Insert into select
View as plain text  
>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. 416 203-7465
Fax. 416 203-3044
Email cj@stripped


Thread
Insert into selectMick Hanna28 Apr
  • Re: Insert into selectsasha28 Apr
Re: Insert into selectChristopher R. Jones28 Apr
  • Re: Insert into selectThimble Smith29 Apr
  • Re: Insert into selectJan Dvorak2 May