Help for this page

Select Code to Download


  1. or download this
    my $dbh = DBI->connect($dsn, $user, $password,
             { RaiseError => 1, AutoCommit => 0 });
...

# commit the transaction
$dbh->do( "COMMIT" );
  2. or download this
    LOCK TABLES table1 WRITE, table2 WRITE

INSERT INTO table1 SELECT * FROM table2;

UNLOCK TABLES