CODEWITHSUNDEEP
mysql
zloctb
zloctb

Reputation: 11184

Myisam suport SET AUTOCOMMIT mode?

/* MyISAM */
SET AUTOCOMMIT = 0;

INSERT INTO table_name (table_field) VALUES ('foo');
INSERT INTO table_name (table_field) VALUES ('bar');

SET AUTOCOMMIT = 1

Warning | 1196 | Some non-transactional changed tables couldn't be rolled back

Myisam suport SET AUTOCOMMIT mode ?

Upvotes: 0

Views: 1357

Answers (1)

Bastian
Bastian

Reputation: 261

MyISAM effectively works in auto-commit mode (as it's not a transactional engine), and it just ignores the commit and Rollback.

Please visit this link

http://dev.mysql.com/doc/refman/5.1/en/pluggable-storage-overview.html

Upvotes: 2

Related Questions