Chcialem sobie potestowac transakcje dla Mysqla w zwiazku z czym napisalem maly skrypt debufgujacy. Oto jego output.
Kod
Nr: 0
SQL => SET AUTOCOMMIT = 0
Result => Success
Rows => 0
Time => 0.00014
Nr: 1
SQL => START TRANSACTION
Result => Success
Rows => 0
Time => 4E-05
Nr: 2
SQL => DELETE FROM test WHERE id=99
Result => Success
Rows => 0
Time => 0.05455
Nr: 3
SQL => SELECT * FROM test
Result => Success
Rows => 90
Time => 0.00554
Nr: 4
SQL => SELECT * FROM bla
Result => Table 'Myooch_New.bla' doesn't exist
Rows => -1
Time => 6E-05
Nr: 5
SQL => INSERT INTO test SET id = 1, di = 'emma'
Result => Success
Rows => 1
Time => 0.00013
Nr: 6
SQL => INSERT INTO test SET id = 4, di = 'get'
Result => Success
Rows => 1
Time => 6E-05
Nr: 7
SQL => INSERT INTO test SET id = 4, di = 'get'
Result => Success
Rows => 1
Time => 6E-05
Nr: 8
SQL => SELECT * FROM test WHERE id = 4
Result => Success
Rows => 62
Time => 0.00061
Nr: 9
SQL => ROLLBACK
Result => Success
Rows => 0
Time => 3E-05
Nr: 10
SQL => SET AUTOCOMMIT = 1
Result => Success
Rows => 0
Time => 3E-05
SQL => SET AUTOCOMMIT = 0
Result => Success
Rows => 0
Time => 0.00014
Nr: 1
SQL => START TRANSACTION
Result => Success
Rows => 0
Time => 4E-05
Nr: 2
SQL => DELETE FROM test WHERE id=99
Result => Success
Rows => 0
Time => 0.05455
Nr: 3
SQL => SELECT * FROM test
Result => Success
Rows => 90
Time => 0.00554
Nr: 4
SQL => SELECT * FROM bla
Result => Table 'Myooch_New.bla' doesn't exist
Rows => -1
Time => 6E-05
Nr: 5
SQL => INSERT INTO test SET id = 1, di = 'emma'
Result => Success
Rows => 1
Time => 0.00013
Nr: 6
SQL => INSERT INTO test SET id = 4, di = 'get'
Result => Success
Rows => 1
Time => 6E-05
Nr: 7
SQL => INSERT INTO test SET id = 4, di = 'get'
Result => Success
Rows => 1
Time => 6E-05
Nr: 8
SQL => SELECT * FROM test WHERE id = 4
Result => Success
Rows => 62
Time => 0.00061
Nr: 9
SQL => ROLLBACK
Result => Success
Rows => 0
Time => 3E-05
Nr: 10
SQL => SET AUTOCOMMIT = 1
Result => Success
Rows => 0
Time => 3E-05
Jak najpierw wysylam zapytanieustawiajace Autocommit na zero, zaczynam transakcje wstawiam dane do bazy a pozniej zamiast ja "popelnic" - anuluje. Jednak info mimo wszystko laduje w bazie. Dlaczego ?