Retro Eye care Haitian Deep Dark Default

SHOW DEFAULT SHADOW ALGORITHM

Description

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

Syntax

ShowDefaultShadowAlgorithm::=
  'SHOW' 'DEFAULT' 'SHADOW' 'ALGORITHM' ('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 default shadow algorithm for specified database.
SHOW DEFAULT SHADOW ALGORITHM FROM shadow_db;
mysql> SHOW DEFAULT SHADOW ALGORITHM 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 default shadow algorithm for current database.
SHOW DEFAULT SHADOW ALGORITHM;
mysql> SHOW DEFAULT SHADOW ALGORITHM;
+-------------------------+-------------+-----------------------------------------+
| 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, ALGORITHM, FROM