SHOW AUTOCOMMIT

Core command AUTOCOMMIT SH AU SHAU

Shows whether autocommit is on or off for the current connection.

Syntax

SHOW AUTOCOMMIT

Examples

SHOW AUTOCOMMIT;

Details

When autocommit is on, the command shows a warning: every update is committed at once and cannot be rolled back. When it is off, it shows Autocommit OFF. CONNECT runs it automatically after connecting.

SET AUTOCOMMIT
SHOW DBINFOS

Last modified in release 5.5.0.

Found something wrong or unclear on this page? Tell us, with the page address.

SHOW AUTOCOMMIT

Syntax

Examples

Details

Related