SHOW TRANSACTION RULE

Description

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

Syntax

Grammar Railroad diagram

  1. ShowTransactionRule ::=
  2.   'SHOW' 'TRANSACTION' 'RULE'

Return Value Description

ColumnDescription
usersusers
providerprivilege provider type
propsprivilege properties

Example

  • Query transaction rule configuration
  1. SHOW TRANSACTION RULE;
  1. mysql> SHOW TRANSACTION RULE;
  2. +--------------+---------------+-------+
  3. | default_type | provider_type | props |
  4. +--------------+---------------+-------+
  5. | LOCAL        |               |       |
  6. +--------------+---------------+-------+
  7. 1 row in set (0.05 sec)

Reserved word

SHOW, TRANSACTION, RULE