mysql transaction

기존에는 트랜잭션을 mysql에서 지원하지 않았던 걸로 기억을 했는데 4.0 이후부터 지원을 하나보다..

MySQL Server (version 3.23-max and all versions 4.0 and above) supports transactions with the InnoDB and BDBtransactional storage engines. InnoDB provides full ACID compliance. [링크 : https://dev.mysql.com/doc/refman/5.0/en/ansi-diff-transactions.html]

[링크 : http://www.tested.co.kr/board/Study/view/wr_id/14/sca/3]
[링크 : https://www.okjsp.net/seq/16222]

/* turn autocommit on */ mysqli_autocommit($link, TRUE); if ($result = mysqli_query($link, "SELECT @@autocommit")) {     $row = mysqli_fetch_row($result);     printf("Autocommit is %s\n", $row[0]);     mysqli_free_result($result); }   [링크 : http://www.php.net/manual/en/mysqli.autocommit.php]