laravel 事务

2019独角兽企业重金招聘Python工程师标准>>>

表必须是InnoDB引擎

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

DB::beginTransaction(); try{     $name = 'abc';     $result1 = Test::create(['name'=>$name]);     if (!$result1) {         /**          * Exception类接收的参数          * $message = "", $code = 0, Exception $previous = null          */         throw new \Exception("1");     }     $result2 = Test::create(['name'=>$name]);     if (!$result2) {         throw new \Exception("2");     }     DB::commit(); } catch (\Exception $e){     DB::rollback();//事务回滚     echo $e->getMessage();     echo $e->getCode(); }

　　注意：如果id是自增的话，mysql的primary key是在内存中维护的，事务回滚是不会回退id，所以中间会出现断层

转载于:https://my.oschina.net/guozhouyuan/blog/1975560