Retro Eye care Haitian Deep Dark Default

SHOW TRANSACTION RULE

Description

The SHOW TRANSACTION RULE syntax is used to query transaction rule configuration.

Syntax

ShowTransactionRule ::=
  'SHOW' 'TRANSACTION' 'RULE'

Return Value Description

Column Description
default_type Default transaction type
provider_type Transaction manager provider type
props Transaction manager properties

Example

  • Query transaction rule configuration
SHOW TRANSACTION RULE;

mysql> SHOW TRANSACTION RULE;
+--------------+---------------+-------+
| default_type | provider_type | props |
+--------------+---------------+-------+
| LOCAL        |               |       |
+--------------+---------------+-------+
1 row in set (0.05 sec)

Reserved word

SHOW, TRANSACTION, RULE