Database Handle Attributes | Mastering MySQL 4

Database handle attributes are those available only to a database handle.

AutoCommit

AutoCommit (boolean)

If set to true, then SQL statements are automatically committed. If false, they are part of a transaction by default and need to be committed or rolled back.

Driver

Driver (handle)

Contains the handle of the parent driver.

For example:

  $dbh->{Driver}->{Name}

Name

Name (string)

The database name.

RowCacheSize

RowCacheSize (integer)

The size the application would like the local row cache to be or undef if the row cache is not implemented. Setting it to a negative number specifies memory size to be used for caching, 0 has the size automatically determined, 1 disables the cache, and a larger positive number is the size of the cache in rows.

Statement

Statement (string, read-only)

The most recent SQL statement passed to prepare().