Help for this page
INSERT INTO A (col1,col2,col3) SELECT fld1,fld2,fld3 FROM B;
my @pats = (); my $dbh = DBI->connect("DBI:mysql:database=proyecto;host=localhost", ... # TODO: CREATE TABLE NAMED $_ HERE ? $dbh->do("INSERT INTO $_(col1,col2,col3) SELECT fld1,fld2,fld3 FR +OM patente WHERE pat = $_"); }