autocommit

autocommit setting sets the autocommit property of the queries.

This is a session setting.

The default value is JDBC driver dependent, although it is usually on.

Syntax

usage: .set autocommit [on | off]

Executing the setting without arguments will display the autocommit setting for the current session.

JDBC Call

It corresponds to JDBC Connection class’s getAutoCommit() and setAutoCommit(boolean autoCommit) functions.