mysql有没有数据插入失败后回滚的功能??

就  function folderAdd_pword($Fgp_Fid,$power){
    global $sql;//slq.class
    $rst = 0;
    foreach($power as $Fgp_Gid=>$Fgp_power){
      $query = "insert into table set Fgp_Gid='".$Fgp_Gid."',Fgp_power='".$Fgp_power."'";
      if($sql->query($query)){
         $rst= $rst+0;
      }else{
         echo  $query ;
         $rst = $rst+1;
      }
    }
    return $rst;
  }就知道那。