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