Retro Eye care Haitian Deep Dark Default

SHOW DEFAULT SHADOW ALGORITHM

Description

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

Syntax

ShowEncryptAlgorithm::=
  'SHOW' 'SHADOW' 'ALGORITHMS' ('FROM' databaseName)?

databaseName ::=
  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

Column Description
shadow_algorithm_name Shadow algorithm name
type Shadow algorithm type
props Shadow algorithm properties

Example

  • Query shadow algorithms for specified database.
SHOW DEFAULT SHADOW ALGORITHMS FROM shadow_db;

mysql> SHOW DEFAULT SHADOW ALGORITHMS FROM shadow_db;
+-------------------------+-------------+-----------------------------------------+
| shadow_algorithm_name   | type        | props                                   |
+-------------------------+-------------+-----------------------------------------+
| user_id_match_algorithm | VALUE_MATCH | column=user_id,operation=insert,value=1 |
+-------------------------+-------------+-----------------------------------------+
1 row in set (0.00 sec)
  • Query shadow algorithms for current database.
SHOW SHADOW ALGORITHMS;

mysql> SHOW SHADOW ALGORITHMS;
+-------------------------+-------------+-----------------------------------------+
| shadow_algorithm_name   | type        | props                                   |
+-------------------------+-------------+-----------------------------------------+
| user_id_match_algorithm | VALUE_MATCH | column=user_id,operation=insert,value=1 |
+-------------------------+-------------+-----------------------------------------+
1 row in set (0.00 sec)

Reserved word

SHOW, DEFAULT,SHADOW, ALGORITHMS, FROM