Perl Monk, Perl Meditation | |
PerlMonks |
Re: DBI insert statementby tweetiepooh (Hermit) |
on Nov 22, 2016 at 15:40 UTC ( [id://1176346]=note: print w/replies, xml ) | Need Help?? |
Looking at the examples it seems the structures of the tables is the same, you are inserting a subset to the new table. If so and there isn't some other parsing happening can't you offload the whole to the database insert into targettable select * from sourcetable where ...If target doesn't need to permanently exist you can create targettable as (select * from sourcetable where...)Then drop the new table at end of run.
In Section
Seekers of Perl Wisdom
|
|