오픈비 : 삽질은없다

트랜잭션을 위한 준비




트랜잭션 테스트






테스트를 위한 table schema


CREATE TABLE trans

(

id int not null auto_increment,

item varchar(30) not null,

quantity varchar(10) not null,

primary key(id)

)type=innodb;
php sample

@mysql_connect("localhost","username",   "password") or die(mysql_error());
@mysql_select_db("test")   or die(mysql_error());
$query = "INSERT INTO trans   (id,item,quantity)
values (null,'Baseball',4)";

@mysql_query("BEGIN");   // transaction begins

$result = @mysql_query($query);
 
if(!$result)
{
	@mysql_query("ROLLBACK");   // transaction rolls back
	echo "you rolled back";
	exit;
}
 
else
{
	@mysql_query("COMMIT"); // transaction is committed
	echo "your insertion was successful";
}