MySQL 에서 트랜잭션 사용하기";
$query = "BEGIN ";
mysql_query($query);
$query = "INSERT INTO $table VALUES(1, '지누스1', 27) ";
mysql_query($query);
$query = "INSERT INTO $table VALUES(2, '지누스2', 27) ";
mysql_query($query);
$query = "INSERT INTO $table VALUES(3, '지누스3', 27) ";
mysql_query($query);
$query = "INSERT INTO $table VALUES(4, '지누스4', 27) ";
mysql_query($query);
$query = "COMMIT ";
mysql_query($query);
$query = "SELECT * FROM $table";
$re = mysql_query($query);
echo "Insert Data :
";
while($row = mysql_fetch_array($re)) {
echo "$row[0], $row[1], $row[2]
\n";
}
echo "End Insert\n";
#
# ROLLBACK Test
#
$query = "BEGIN";
mysql_query($query);
$query = "INSERT INTO transaction_test VALUES(5, '지누스5', 27)";
mysql_query($query);
$query = "INSERT INTO transaction_test VALUES(6, '지누스6', 27)";
mysql_query($query);
$query = "INSERT INTO transaction_test VALUES(7, '지누스7', 27)";
mysql_query($query);
$query = "INSERT INTO transaction_test VALUES(8, '지누스8', 27)";
$query = "SELECT * FROM transaction_test";
mysql_query($query);
$query = "ROLLBACK";
mysql_query($query);
$query = "SELECT * FROM transaction_test";
$re = mysql_query($query);
# 결과 보기
echo "Roolback Test : 위 결과랑 같으면 성공한 것이다.
";
while($row = mysql_fetch_array($re)) {
echo "$row[0], $row[1], $row[2]
\n";
}
echo "End RollBack\n";
echo mysql_error();
mysql_close();
?>