SHOW DEFAULT SHADOW ALGORITHM

Description

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

Syntax

Grammar Railroad diagram

  1. ShowEncryptAlgorithm::=
  2. 'SHOW' 'SHADOW' 'ALGORITHMS' ('FROM' databaseName)?
  3. databaseName ::=
  4. 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

Example

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

Reserved word

SHOW, DEFAULT,SHADOW, ALGORITHMS, FROM