MySQL AUTOCOMMIT status while using BEGIN and START TRANSACTION -


i need use transaction in project on mysql. i'm not sure if have use mysql_query("set autocommit=0"); or not.
know have 2 options:

  1. begin
  2. start transaction

also have heard 1 of both items not need using autocommit = 0.
please me know when have use autocommit = 0 actually, begin or start transaction?

thank you.

as explained in the manual:

by default, mysql runs autocommit mode enabled. means execute statement updates (modifies) table, mysql stores update on disk make permanent. change cannot rolled back.

to disable autocommit mode implicitly single series of statements, use start transaction statement:

start transaction; select @a:=sum(salary) table1 type=1; update table2 set summary=@a type=1; commit;

with start transaction, autocommit remains disabled until end transaction commit or rollback. autocommit mode reverts previous state.

the manual goes on say:

to disable autocommit mode explicitly, use following statement:

set autocommit=0;

after disabling autocommit mode setting autocommit variable zero, changes transaction-safe tables (such innodb or ndbcluster) not made permanent immediately. must use commit store changes disk or rollback ignore changes.

autocommit session variable , must set each session. disable autocommit mode each new connection, see description of autocommit system variable @ section 5.1.3, “server system variables”.

begin , begin work supported aliases of start transaction initiating transaction. start transaction standard sql syntax , recommended way start ad-hoc transaction.


Comments

Post a Comment

Popular posts from this blog

javascript - backbone.js Collection.add() doesn't `construct` (`initialize`) an object -

<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> <script src="http://documentcloud.github.com/backbone/backbone-min.js"></script> </head> <body> <button id="cmd_create_event" name="cmd_create_event" type="button">create new `event`</button> <script type="text/javascript"> var eventmodel = backbone.model.extend({ initialize : function() { console.log("`event` initialized. id: " + this.cid); this.bind("change:status", function() { console.log(this.get("status") + " value `status`"); }); this.bind("error", function(model, e...
Read more

php - Get uncommon values from two or more arrays -

is there function in php give array of uncommon values 2 or more arrays? for example: $array1 = array( "green", "red", "blue"); $array2 = array( "green", "yellow", "red"); .... $result = function_needed($array1, $array2,...); print_r($result); should give output: array("blue", "yellow", ...); use array_diff , array_merge : $result = array_merge(array_diff($array1, $array2), array_diff($array2, $array1)); here's demo. for multiple arrays, combine callback , array_reduce : function unique(&$a, $b) { return $a ? array_merge(array_diff($a, $b), array_diff($b, $a)) : $b; } $arrays = array( array('green', 'red', 'blue'), array('green', 'yellow', 'red') ); $result = array_reduce($arrays, 'unique'); and here's demo of that.
Read more

Adding duplicate array rows in Php -

i create function in php adds rows of array shared column value. so input. $test = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); and output. $testduplicatefree = array( array("c", 7, 9), array("test", 5, 6) ) ); i'm thinking function combine_duplicates($array,$col){ ... ... return $duplicatefreearray; } where $col duplicate free array. so, in case, combine_duplicates($test,0); would me desired output. this. <?php function combine_duplicates($array,$col) { $index = array(); foreach ($array $row) { $key = $row[$col]; if (!isset($index[$key])) { $index[$key] = $row; } else { ($i = 0; $i < count($row); ++$i) { if ($i != $col) { $index[$key][$i] += $row[$i]; } } } } return array_values($index); } $array = array( array("c", 5, 6), array("c", 2, 3), array("test", 5, 6) ); print_r(combine_duplicates($array, 0)); try here: http://codepad.org/mdhesqhi
Read more