Help for this page

Select Code to Download


  1. or download this
    INSERT INTO A (col1,col2,col3) SELECT fld1,fld2,fld3 FROM B;
    
  2. or download this
    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 = $_");
    }