and although it may work and is only an example it is also a prime example of doing something in Perl that could be better done in the database - insert into bbb (num, name) select num, name from aaa. I sincerely hope the OP is not doing something like this.