mysql 插入前锁表问题

最新推荐文章于 2024-01-28 23:53:56 发布

weixin_30757793

最新推荐文章于 2024-01-28 23:53:56 发布

阅读量277

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/zhaoyangjian724/p/6199329.html

版权

$dbh = DBI->connect("dbi:mysql:database=$db_name;host=$ip;port=3306",$user,$passwd,{
                          RaiseError => 1,
                          AutoCommit => 0
                        }) or die "can't connect to database ". DBI-errstr;
     eval{
    $dbh->do("select count(*) from t1 for update") ;
    $dbh->do("insert into t1 values(87)") ;
     $dbh->commit;
        };
    if( $@ ) {
    #warn "Database error: $DBI::errstr\n";
    $dbh->rollback(); #just die if rollback is failing 
    	 };
  $dbh->disconnect;

转载于:https://www.cnblogs.com/zhaoyangjian724/p/6199329.html