SHOW SHADOW ALGORITHM

Description

The SHOW SHADOW ALGORITHM syntax is used to query shadow algorithms for specified database.

Syntax

  1. ShowEncryptAlgorithm::=
  2.   'SHOW' 'SHADOW' 'ALGORITHMS' ('FROM' databaseName)?
  4. databaseName ::=
  5.   identifier

Supplement

  • When databaseName is not specified, the default is the currently used DATABASE. If DATABASE is not used, No database selected will be prompted.

Return value description

ColumnDescription
shadow_algorithm_nameShadow algorithm name
typeShadow algorithm type
propsShadow algorithm properties
is_defaultDefault

Example

  • Query shadow algorithms for specified database.
  1. SHOW SHADOW ALGORITHMS FROM test1;
  1. mysql> SHOW SHADOW ALGORITHMS FROM test1;
  2. +-------------------------+-------------+-----------------------------------------+------------+
  3. | shadow_algorithm_name   | type        | props                                   | is_default |
  4. +-------------------------+-------------+-----------------------------------------+------------+
  5. | user_id_match_algorithm | VALUE_MATCH | column=user_id,operation=insert,value=1 | false      |
  6. +-------------------------+-------------+-----------------------------------------+------------+
  7. 1 row in set (0.00 sec)
  • Query shadow algorithms for current database.
  1. SHOW SHADOW ALGORITHMS;
  1. mysql> SHOW SHADOW ALGORITHMS;
  2. +-------------------------+-------------+-----------------------------------------+------------+
  3. | shadow_algorithm_name   | type        | props                                   | is_default |
  4. +-------------------------+-------------+-----------------------------------------+------------+
  5. | user_id_match_algorithm | VALUE_MATCH | column=user_id,operation=insert,value=1 | false      |
  6. +-------------------------+-------------+-----------------------------------------+------------+
  7. 1 row in set (0.00 sec)

Reserved word

SHOW, SHADOW, ALGORITHMS, FROM