Re: Efficient select/insert

[Jonathan Mangin]

----- Original Message ----- 
From: "Philip M. Gollucci" <[EMAIL PROTECTED]>
To: "Jonathan Mangin" <[EMAIL PROTECTED]>
Cc: <dbi-users@perl.org>
Sent: Tuesday, April 26, 2005 3:19 PM
Subject: Re: Efficient select/insert


Jonathan Mangin wrote:
I would like to select several rows from one table
and insert them into another nearly identical table
using Perl/DBI:
my @array = $q->param();  # HTML checkboxes
foreach my $element (@array) {
   $dbh->do("INSERT INTO t (col1, ...) SELECT col1, ... FROM t2 WHERE x = 
'$element'");
}

--
END
-----------------------------------------------------------------------------
Philip M. Gollucci
Senior Developer - Liquidity Services Inc.
Phone:  202.558.6268 (Direct)
E-Mail: [EMAIL PROTECTED]
Web:    http://www.liquidation.com

oh
That's graceful. Thanks.
So to loop through ~150 tiny rows is probably no hardship
on the db engine.(?)
--Jon