Autocommit acting crazy !!

[d.shankar]

Hi all .. the autocommit feature is driving me crazy

 

I have the set the autocommit feature to off , when i run this query it still truncates my table and commits it.

The below is the code can someone help me ?

 

<?php

$mysqli=new mysqli('localhost','username','password','dbname');
if(mysqli_connect_errno()){
    trigger_error('Error connecting to host. '.$mysqli->error,E_USER_ERROR);
}


$mysqli->autocommit(FALSE);

$mysqli->query("TRUNCATE table testing");



?>

 

Please dont bring on commit and rollback here , since the basic feature does not seem to work.

 

[ignace]

what is your db table type? autocommit() does not work with MyISAM or ISAM, you probably know this if you read the manual

[d.shankar]

Please i am not that much n00b. ., I know that it wont work with MyISAM ..etc

 

Mine is InnoDB.

 

Anyway thank you for reply.

[d.shankar]

Bump1

[d.shankar]

I tried even this.. still no use

 

<?php

$mysqli=new mysqli('localhost','root','','test');
if(mysqli_connect_errno()){
    trigger_error('Error connecting to host. '.$mysqli->error,E_USER_ERROR);
}

$mysqli->autocommit(FALSE);
$mysqli->query("TRUNCATE table testing");
$mysqli->rollback();
$mysqli->close();

?>

 

Still the table gets truncated  ???

[d.shankar]

Bump2

 

Any experienced mods worked with mysqli ??

[corbin]

Is TRUNCATE TABLE supported in transactions?

[d.shankar]

It should support. I heard that only CREATE TABLE & CREATE DATABASE are not supported.